Re: PG13 Autovacuum for Insert

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.