From 8b1769035969dc72dab27edd43c7d8667eebaaf9 Mon Sep 17 00:00:00 2001
From: Ellie Huxtable <ellie@elliehuxtable.com>
Date: Mon, 1 Jul 2024 13:49:46 +0100
Subject: perf: create idx cache table (#2140)

* perf: add idx cache

* Update crates/atuin-server-postgres/migrations/20240614104159_idx-cache.sql

* indentation

* remove trigger - for each row is too much, should be once per transaction
---
 .../atuin-server-postgres/migrations/20240614104159_idx-cache.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 crates/atuin-server-postgres/migrations/20240614104159_idx-cache.sql

(limited to 'crates/atuin-server-postgres/migrations/20240614104159_idx-cache.sql')

diff --git a/crates/atuin-server-postgres/migrations/20240614104159_idx-cache.sql b/crates/atuin-server-postgres/migrations/20240614104159_idx-cache.sql
new file mode 100644
index 00000000..76425ed7
--- /dev/null
+++ b/crates/atuin-server-postgres/migrations/20240614104159_idx-cache.sql
@@ -0,0 +1,8 @@
+create table store_idx_cache(
+  id bigserial primary key, 
+  user_id bigint,
+
+  host uuid,
+  tag text,
+  idx bigint
+);
-- 
cgit v1.3.1

