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,