News for hackers. Stuff that matters.
Re:Index bloat reduced in PostgreSQL v14 by gmokki on Sunday September 12, 2021 @08:21AM (#28500501)
Because the user is using values that are no longer covered by the statistics. For example incrementing timestamp or id column. If the stats are from yesterday and they say nothing about the frequency of todays timestamps the query will have to take a pessimistic view of the world. It might be that the data has radically changed since the last stats run, or not. Need to analyze the table to know and make optimal choices.

There are no comments on this comment yet.