RE: VACUUM freeze - Mailing list pgsql-admin

From Dave Bolt
Subject RE: VACUUM freeze
Date
Msg-id 000f01d615d1$b0f14b80$12d3e280$@co.uk
Whole thread Raw
In response to VACUUM freeze  (Arnav <justdba03@gmail.com>)
Responses Re: VACUUM freeze  (Ankush Chawla <ankushchawla03@gmail.com>)
List pgsql-admin

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@gmail.com]
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

pgsql-admin by date:

Previous
From: Arnav
Date:
Subject: VACUUM freeze
Next
From: Ankush Chawla
Date:
Subject: Re: VACUUM freeze