On 7/8/21 8:38 AM, Keith Fiske wrote: [snip]
Vacuum also keeps the freespacemap and visibility maps updated as well. Not quite as critical for insert-only tables, but it can still influence query planning. Having an up to date visibility-map can help index-only scans happen more frequently if possible.
We've got INSERT-only tables, and the query planner only used sequential scans (on a freshly loaded 6TB database) until I vacuumed all tables,
-- Angular momentum makes the world go 'round.
