Re: PG13 Autovacuum for Insert

Thanks Keith and Ron. Now, I understood better.

Thanks,
Raj Kumar Narendiran.

On Thu, 8 Jul 2021, 20:29 Ron, <ronljohnsonjr(at)gmail(dot)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.
>
>
>