hard20 pts · first answer countspostgresqlperformance

Indexes bloat on a counter table

A table is updated thousands of times a second, changing only a non-indexed last_seen column, yet its indexes grow quickly. What would most help?

A.Add more indexes so updates are spread outB.Switch to SERIALIZABLE isolationC.Run REINDEX every minuteD.Lower fillfactor (for example 70) so new row versions fit on the same page as HOT updates, skipping index changes

← Risky SECURITY DEFINER function Random UUID keys slow down inserts →