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
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 |