diff options
| author | Ellie Huxtable <ellie@elliehuxtable.com> | 2024-07-01 13:49:46 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-07-01 13:49:46 +0100 |
| commit | 8b1769035969dc72dab27edd43c7d8667eebaaf9 (patch) | |
| tree | 25a45d0b68d3e0620f02417387bdf5ca4bcfaa07 /crates/atuin-server-postgres/migrations | |
| parent | chore(deps): bump @headlessui/react from 2.1.0 to 2.1.1 in /ui (#2218) (diff) | |
| download | atuin-8b1769035969dc72dab27edd43c7d8667eebaaf9.zip | |
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
Diffstat (limited to 'crates/atuin-server-postgres/migrations')
| -rw-r--r-- | crates/atuin-server-postgres/migrations/20240614104159_idx-cache.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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 +); |