[abraxas]

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]

Using BRIN for certain columns resulted in an improvement. Thanks for the suggestion.