Re: New vacuum option to do only freezing - Mailing list pgsql-hackers

From Greg Stark
Subject Re: New vacuum option to do only freezing
Date
Msg-id CAM-w4HM1mV_KATdTVxY8hHtbgG-=GxZemDa2i3c+QT=weUqapw@mail.gmail.com
Whole thread Raw
In response to Re: New vacuum option to do only freezing  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: New vacuum option to do only freezing  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers


On Mon 5 Nov 2018, 12:49 Robert Haas <robertmhaas@gmail.com wrote:
That seems non-orthogonal.  We have an existing flag to force freezing
(FREEZE); we don't need a second option that does the same thing.
Skipping the index scans (and thus necessarily the second heap pass)
is a separate behavior which we don't currently have a way to control.

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 

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: pread() and pwrite()
Next
From: Robert Haas
Date:
Subject: Re: New vacuum option to do only freezing