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:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2018-06-13 20:29:12 from "Bossart, Nathan" <bossartn(at)amazon(dot)com> 📎  2018-07-12 05:37:28 from Michael Paquier <michael(at)paquier(dot)xyz>   2018-07-17 06:21:48 from Michael Paquier <michael(at)paquier(dot)xyz>    2018-07-17 11:30:40 from Robert Haas <robertmhaas(at)gmail(dot)com>    2018-07-18 16:58:48 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>     2018-07-19 01:54:23 from Michael Paquier <michael(at)paquier(dot)xyz>      2018-07-23 03:10:58 from Michael Paquier <michael(at)paquier(dot)xyz> 📎       2018-07-23 14:27:48 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>        2018-07-24 02:40:49 from Michael Paquier <michael(at)paquier(dot)xyz>         2018-07-24 17:21:25 from "Bossart, Nathan" <bossartn(at)amazon(dot)com> 📎          2018-07-25 01:06:32 from Michael Paquier <michael(at)paquier(dot)xyz>           2018-07-29 22:56:24 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>            2018-09-03 23:19:46 from Michael Paquier <michael(at)paquier(dot)xyz>             2018-09-04 15:49:09 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>              2018-09-04 18:30:40 from Michael Paquier <michael(at)paquier(dot)xyz>               2018-09-05 15:24:21 from "Bossart, Nathan" <bossartn(at)amazon(dot)com> 📎                2018-09-27 07:51:52 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                 2018-10-01 15:37:01 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>                  2018-10-02 00:06:33 from Michael Paquier <michael(at)paquier(dot)xyz>                   2018-10-02 02:22:42 from "Bossart, Nathan" <bossartn(at)amazon(dot)com> 📎                    2018-10-03 05:52:47 from Michael Paquier <michael(at)paquier(dot)xyz>                     2018-10-03 16:20:42 from "Bossart, Nathan" <bossartn(at)amazon(dot)com> 📎                      2018-10-04 00:09:11 from Michael Paquier <michael(at)paquier(dot)xyz>                       2018-10-04 01:32:47 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>
Lists:	pgsql-hackers

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

• Re: Add SKIP LOCKED to VACUUM and ANALYZE at 2018-07-12 05:37:28 from Michael Paquier

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