diff options
| author | Ellie Huxtable <ellie@elliehuxtable.com> | 2022-04-26 09:32:59 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-04-26 09:32:59 +0100 |
| commit | 4030de4bea0f3b2d4e9a9f9d581fe2657b61eac1 (patch) | |
| tree | 058b7210999212d03fdcddf291a7ffc6b2092e80 | |
| parent | Bump tower-http from 0.2.5 to 0.3.0 (#343) (diff) | |
| download | atuin-4030de4bea0f3b2d4e9a9f9d581fe2657b61eac1.zip | |
Add btree index on history table (#345)
This speeds up a whole bunch of our queries by a *lot* :)
| -rw-r--r-- | atuin-server/migrations/20220426080938_history-index.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/atuin-server/migrations/20220426080938_history-index.sql b/atuin-server/migrations/20220426080938_history-index.sql new file mode 100644 index 00000000..2d2a5633 --- /dev/null +++ b/atuin-server/migrations/20220426080938_history-index.sql @@ -0,0 +1 @@ +create index concurrently if not exists "history_idx" on history using btree (user_id, timestamp); |