Re: Add SKIP LOCKED to VACUUM and ANALYZE

On 9/4/18, 1:32 PM, "Michael Paquier" <michael(at)paquier(dot)xyz> wrote:
>On Tue, Sep 04, 2018 at 03:49:09PM +0000, Bossart, Nathan wrote:
>> Yes. I've started working on this again, but the new patch set is
>> probably still a few days out.
>
> Thanks, Nathan.

And here it is. Here is a summary of the notable changes:

1) Patches v8-0003 and v8-0008 have been discarded. These patches
added SKIP_LOCKED behavior when opening a relation's indexes.
Instead, I've documented that VACUUM and ANALYZE may still block
on indexes in v9-0007.
2) Patches v8-0004 and v8-0005 have been discarded, as they have
already been committed.
3) Patch v8-0011 has been discarded. As previously noted, VACUUM
(SKIP_LOCKED, FULL) is already handled in vacuum_rel(), so no
changed are required to cluster_rel(). However, we will need
something similar to v8-0011 if we ever add SKIP_LOCKED to
CLUSTER.
4) The option has been renamed to SKIP_LOCKED (with the underscore)
for consistency with the DISABLE_PAGE_SKIPPING option.
5) In the documentation, I've listed the caveats for SKIP_LOCKED and
partitioned tables. I tried to make all the new documentation as
concise as possible.

Nathan