summaryrefslogtreecommitdiffstats
path: root/TODO
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-09-10 16:46:49 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-09-10 16:46:52 -0700
commit2e335344e59de0ff42f1c2797a4e4ffbf3f4b30b (patch)
tree0e385559a4d19fc99d8553ad7b1f29ab06031bb6 /TODO
parentda10d0e0cebc1142852b959cea93c8b80801d565 (diff)
downloadfatcat-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 'TODO')
0 files changed, 0 insertions, 0 deletions