From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Greg Stark <stark(at)mit(dot)edu> |
Cc: | Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: New vacuum option to do only freezing |
Date: | 2018-11-06 02:19:25 |
Message-ID: | CA+TgmoYsQ9xXoR-z51ehYoXPCwrU7duZZzaf-CdN9dOV5PMFOw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Nov 5, 2018 at 9:12 PM Greg Stark <stark(at)mit(dot)edu> wrote:
> It sounds like it might be better to name this "VACUUM (FAST)” and document that it skips some of the normal (and necessary) work that vacuum does and is only suitable for avoiding wraparounds and not sufficient for avoiding bloat
We could do that, but I don't see why that's better than VACUUM
(SKIP_INDEX_SCANS) or similar. There are, perhaps, multiple kinds of
shortcuts that could make vacuum run faster, but skipping index scans
is what it is.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2018-11-06 02:25:28 | Re: First-draft release notes for back-branch releases |
Previous Message | Greg Stark | 2018-11-06 02:12:30 | Re: New vacuum option to do only freezing |