thanks for reply
Then what would be way if we want some tables to be skipped for autovacuum.
What do you think, what should we do?
This will enable for older version to stay.
On Sun, Apr 19, 2020 at 4:05 AM Dave Bolt <dave@xxxxxxxxxxxxxx> wrote:
Hi Arnav,
Could be wrong here, in which case someone will jump in.
My understanding is that freeze only applies while doing the vacuum, and then only when doing a manual vacuum.
I looked at the documentation at https://www.postgresql.org/docs/current/sql-vacuum.html and https://www.postgresql.org/docs/current/routine-vacuuming.html to try to confirm, but did feel a little confused.
Hope this helps a bit.
Dave
From: Arnav [mailto:justdba03@xxxxxxxxx]
Sent: 18 April 2020 19:26
To: pgsql-admin
Subject: VACUUM freeze
hi
what is VACUUM freeze , does it not allow autovacuum to happen ever.
if yes till how long?
--
Regards
Arnav
Best Regards,
Ankush Chawla
Ankush Chawla
