Re: VACUUM freeze

Поиск
Список
Период
Сортировка
От Ankush Chawla
Тема Re: VACUUM freeze
Дата
Msg-id CAOY8JhC3Bw4OWQHRRcxpFRLO=_pB+=Mj16SXxWixGb+Oh9=7vA@mail.gmail.com
обсуждение исходный текст
Ответ на RE: VACUUM freeze  ("Dave Bolt" <dave@davebolt.co.uk>)
Ответы Re: VACUUM freeze  (Scott Ribe <scott_ribe@elevated-dev.com>)
Re: VACUUM freeze  (Olivier Gautherot <ogautherot@gautherot.net>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Bolt"
Дата:
Сообщение: RE: VACUUM freeze
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: VACUUM freeze