Home > mailing lists

Add SKIP LOCKED to VACUUM and ANALYZE - Mailing list pgsql-hackers

From	Bossart, Nathan
Subject	Add SKIP LOCKED to VACUUM and ANALYZE
Date	June 14, 2018 02:29:12
Msg-id	9EF7EBE4-720D-4CF1-9D0E-4403D7E92990@amazon.com Whole thread Raw
Responses	Re: Add SKIP LOCKED to VACUUM and ANALYZE
List	pgsql-hackers

Tree view

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

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

pgsql-hackers by date:

From: Haribabu Kommi
Date: 14 June 2018, 02:20:51
Subject: Re: [HACKERS] Pluggable storage

From: Andrew Gierth
Date: 14 June 2018, 03:02:13
Subject: Re: Portability concerns over pq_sendbyte?

Add SKIP LOCKED to VACUUM and ANALYZE - Mailing list pgsql-hackers

Attachment

Previous

Next