| 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: | Whole Thread | Raw Message | 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 |