Re: VACUUM freeze

From: Ankush Chawla <ankushchawla03(at)gmail(dot)com>
To: Dave Bolt <dave(at)davebolt(dot)co(dot)uk>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: VACUUM freeze
Date: 2020-04-19 07:15:42
Message-ID: CAOY8JhC3Bw4OWQHRRcxpFRLO=_pB+=Mj16SXxWixGb+Oh9=7vA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)davebolt(dot)co(dot)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(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2020-04-19 12:09:57 Re: VACUUM freeze
Previous Message Dave Bolt 2020-04-18 22:35:41 RE: VACUUM freeze