From 8b1769035969dc72dab27edd43c7d8667eebaaf9 Mon Sep 17 00:00:00 2001 From: Ellie Huxtable 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') 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