Postgres Pro
Downloads
Home   >   mailing lists

Re: PG13 Autovacuum for Insert - Mailing list pgsql-admin

From Raj kumar
Subject Re: PG13 Autovacuum for Insert
Date
Msg-id CACxU--UnWduV2aU7nB8nrUTPtt0X=jQGAWeXbM6D9PswjhWEyA@mail.gmail.com
Whole thread Raw
In response to Re: PG13 Autovacuum for Insert  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
Thanks Keith and Ron. Now, I understood better.

Thanks, 
Raj Kumar Narendiran.

On Thu, 8 Jul 2021, 20:29 Ron, <ronljohnsonjr@gmail.com> wrote:
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.


pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: PG13 Autovacuum for Insert
Next
From: Ivan Petrov
Date:
Subject: Bad value for type BigDecimal : Infinity