TIL: a partial index is usually the answer

FRI 14 AUG 20261 min20 words
0%

create index ... where country_k is not null indexes only the rows you query, which on a mostly-null column is a fraction of the size and strictly faster.

↑ was it any good?

↑ pass it on

joe@joeee.dev:~/comments$ tail -f0 entries

reading…

2000 characters left

Comments are moderated, so yours will not show up straight away.