PG13 Autovacuum for Insert

From: Raj kumar <rajkumar820999(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: PG13 Autovacuum for Insert
Date: 2021-07-08 12:27:01
Message-ID: CACxU--U2R19w-XMqyhk=ZPLNo88D4kVLs35fs9xn+hikgJgnpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

In PG13, we have a new feature where autovacuum gets triggered based on
Insert threshold. I wanted to know why we need autovacuum for Insert
workloads, as there won't be any dead tuples because of them and we already
have Auto analyze for inserts till PG12.

Thanks,
Raj Kumar Narendiran

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith Fiske 2021-07-08 13:38:09 Re: PG13 Autovacuum for Insert
Previous Message Jeff Janes 2021-07-07 20:51:36 Re: WALWriteLock