Add SKIP LOCKED to VACUUM and ANALYZE

From: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Andres Freund <andres(at)anarazel(dot)de>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Lyes Ameddah <lyes(dot)amd(at)gmail(dot)com>
Subject: Add SKIP LOCKED to VACUUM and ANALYZE
Date: 2018-06-13 20:29:12
Message-ID: 9EF7EBE4-720D-4CF1-9D0E-4403D7E92990@amazon.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
v8-0001-Add-skip_locked-argument-to-find_inheritance_chil.patch application/octet-stream 8.6 KB
v8-0002-Add-skip_locked-argument-to-find_all_inheritors.patch application/octet-stream 11.5 KB
v8-0003-Add-skip_locked-argument-to-vac_open_indexes.patch application/octet-stream 3.9 KB
v8-0004-Rename-VACOPT_NOWAIT-to-VACOPT_SKIP_LOCKED.patch application/octet-stream 3.1 KB
v8-0005-Add-assertion-that-we-are-not-an-autovacuum-worke.patch application/octet-stream 970 bytes
v8-0006-Create-a-helper-function-for-determining-the-log-.patch application/octet-stream 4.9 KB
v8-0007-Create-a-helper-function-for-cleaning-up-from-do_.patch application/octet-stream 2.1 KB
v8-0008-Skip-VACUUM-ANALYZE-with-VACOPT_SKIP_LOCKED-if-in.patch application/octet-stream 6.9 KB
v8-0009-Skip-ANALYZE-with-VACOPT_SKIP_LOCKED-if-acquire_i.patch application/octet-stream 4.0 KB
v8-0010-Skip-VACUUM-ANALYZE-with-VACOPT_SKIP_LOCKED-if-ex.patch application/octet-stream 2.6 KB
v8-0011-Skip-VACUUM-FULL-with-VACOPT_SKIP_LOCKED-if-clust.patch application/octet-stream 5.7 KB
v8-0012-Open-up-VACOPT_SKIP_LOCKED-to-users.patch application/octet-stream 13.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gierth 2018-06-13 21:02:13 Re: Portability concerns over pq_sendbyte?
Previous Message Haribabu Kommi 2018-06-13 20:20:51 Re: [HACKERS] Pluggable storage