Re: VACUUM freeze - Mailing list pgsql-admin

From Ankush Chawla
Subject Re: VACUUM freeze
Date
Msg-id CAOY8JhC3Bw4OWQHRRcxpFRLO=_pB+=Mj16SXxWixGb+Oh9=7vA@mail.gmail.com
Whole thread Raw
In response to RE: VACUUM freeze  ("Dave Bolt" <dave@davebolt.co.uk>)
Responses Re: VACUUM freeze
Re: VACUUM freeze
List pgsql-admin
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@davebolt.co.uk> 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@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



--
Best Regards,
Ankush Chawla

pgsql-admin by date:

Previous
From: "Dave Bolt"
Date:
Subject: RE: VACUUM freeze
Next
From: Scott Ribe
Date:
Subject: Re: VACUUM freeze