UNLOG table

ammario · ammario · commit 012a6a26c4f1 · 2023-03-29T22:29:21.000Z
diff --git a/coderd/database/migrations/000111_workspace_agent_metadata.up.sql b/coderd/database/migrations/000111_workspace_agent_metadata.up.sql
@@ -1,4 +1,7 @@
-CREATE TABLE workspace_agent_metadata (
+-- This table is UNLOGGED because it is very update-heavy and the the data 
+-- is not valuable enough to justify the overhead of WAL logging. This should
+-- give us a ~70% improvement in write throughput.
+CREATE UNLOGGED TABLE workspace_agent_metadata (
     workspace_agent_id uuid NOT NULL,
     display_name varchar(127) NOT NULL,
     key varchar(127) NOT NULL,
