3 ms·
if the index updates are your bottleneck you can often get away with using a much lighter index (for example BRIN) at a cost of slightly slower queries. This is
by abraxas 5mo ago
if the index updates are your bottleneck you can often get away with using a much lighter index (for example BRIN) at a cost of slightly slower queries. This is very often a great and much overlooked tradeoff.
- daneel_w 5mo agoUsing BRIN for certain columns resulted in an improvement. Thanks for the suggestion.