Add SKIP LOCKED to VACUUM and ANALYZE

Nathan Bossart <bossartn@amazon.com>

From: "Bossart, Nathan" <bossartn@amazon.com>

To: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Cc: Michael Paquier <michael@paquier.xyz>, Andres Freund <andres@anarazel.de>, Masahiko Sawada <sawada.mshk@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, Lyes Ameddah <lyes.amd@gmail.com>

Date: 2018-06-13T20:29:12Z

Lists: pgsql-hackers

Attachments

v8-0001-Add-skip_locked-argument-to-find_inheritance_chil.patch (application/octet-stream) patch v8-0001
v8-0002-Add-skip_locked-argument-to-find_all_inheritors.patch (application/octet-stream) patch v8-0002
v8-0003-Add-skip_locked-argument-to-vac_open_indexes.patch (application/octet-stream) patch v8-0003
v8-0004-Rename-VACOPT_NOWAIT-to-VACOPT_SKIP_LOCKED.patch (application/octet-stream) patch v8-0004
v8-0005-Add-assertion-that-we-are-not-an-autovacuum-worke.patch (application/octet-stream) patch v8-0005
v8-0006-Create-a-helper-function-for-determining-the-log-.patch (application/octet-stream) patch v8-0006
v8-0007-Create-a-helper-function-for-cleaning-up-from-do_.patch (application/octet-stream) patch v8-0007
v8-0008-Skip-VACUUM-ANALYZE-with-VACOPT_SKIP_LOCKED-if-in.patch (application/octet-stream) patch v8-0008
v8-0009-Skip-ANALYZE-with-VACOPT_SKIP_LOCKED-if-acquire_i.patch (application/octet-stream) patch v8-0009
v8-0010-Skip-VACUUM-ANALYZE-with-VACOPT_SKIP_LOCKED-if-ex.patch (application/octet-stream) patch v8-0010
v8-0011-Skip-VACUUM-FULL-with-VACOPT_SKIP_LOCKED-if-clust.patch (application/octet-stream) patch v8-0011
v8-0012-Open-up-VACOPT_SKIP_LOCKED-to-users.patch (application/octet-stream) patch v8-0012

Hello,

Previous thread: https://postgr.es/m/4BC0F3CD-F4B5-4F23-AADB-80607F9E4B4E%40amazon.com

This is a new thread for tracking the work to add SKIP LOCKED to
VACUUM and ANALYZE.  I've attached a rebased set of patches.

Nathan

Commits

Add option SKIP_LOCKED to VACUUM and ANALYZE
- 803b1301e8c9 12.0 landed
Refactor relation opening for VACUUM and ANALYZE
- e3a25ab9ea56 12.0 landed
Refactor cluster_rel() to handle more options
- 9ebe0572ceab 12.0 landed
Add assertion in expand_vacuum_rel() for non-autovacuum path
- 6551f3daa256 12.0 landed