diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-09-10 16:46:49 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-09-10 16:46:52 -0700 |
| commit | 2e335344e59de0ff42f1c2797a4e4ffbf3f4b30b (patch) | |
| tree | 0e385559a4d19fc99d8553ad7b1f29ab06031bb6 /rust/migrations/00000000000000_diesel_initial_setup | |
| parent | da10d0e0cebc1142852b959cea93c8b80801d565 (diff) | |
| download | fatcat-2e335344e59de0ff42f1c2797a4e4ffbf3f4b30b.tar.gz fatcat-2e335344e59de0ff42f1c2797a4e4ffbf3f4b30b.zip | |
remove 'IS NOT NULL' identifier index constraints
These seemed to be resulting in table scans on 404s in QA with postgres
10, despite the adding "IS NOT NULL" WHERE clauses earlier. Query time
was very significant, even for the creator table (1.2 seconds or so on
SSD).
I looked at using hash indices (which have improved in postgres 10),
which could save index size (disk and RAM) and potentially be faster for
these trivial exact lookups, but didn't go for it at this time.
Diffstat (limited to 'rust/migrations/00000000000000_diesel_initial_setup')
0 files changed, 0 insertions, 0 deletions