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] hi what is VACUUM freeze , does it not allow autovacuum to happen ever. if yes till how long? -- Regards Arnav |