Add SKIP LOCKED option to VACUUM and ANALYZE

Edit
Title Add SKIP LOCKED option to VACUUM and ANALYZE
Topic SQL Commands
Created 2017-12-05 16:56:30
Last modified 2018-10-04 01:46:46 (5 years, 5 months ago)
Latest email 2018-10-04 01:32:47 (5 years, 5 months ago)
Status
2018-11: Committed
2018-09: Moved to next CF
2018-07: Moved to next CF
2018-03: Moved to next CF
2018-01: Moved to next CF
Target version
Authors Nathan Bossart (bossartn)
Reviewers Michael Paquier (michael-kun), Masahiko Sawada (masahikosawada)Become reviewer
Committer Michael Paquier (michael-kun)
Links
Emails
BUG #14941: Vacuum crashes
First at 2017-12-01 16:09:07 by lyes.amd at gmail.com
Latest at 2018-04-06 20:29:33 by "Bossart, Nathan" <bossartn at amazon.com>
Latest attachment (v7-0001-Add-skip_locked-argument-to-find_inheritance_chil.patch) at 2018-04-05 20:29:38 from "Bossart, Nathan" <bossartn at amazon.com>
    Attachment (v7-0001-Add-skip_locked-argument-to-find_inheritance_chil.patch) at 2018-04-05 20:29:38 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (v5-0001-Add-parenthesized-options-syntax-for-ANALYZE.patch) at 2018-03-05 21:55:13 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (v5-0001-Add-parenthesized-options-syntax-for-ANALYZE.patch) at 2018-03-04 00:12:52 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (0003_add_nowait_vacuum_option_v4.patch) at 2018-01-10 17:26:43 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (0003_add_nowait_vacuum_option_v3.patch) at 2017-12-28 22:46:18 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (0001_fix_unparenthesized_vacuum_grammar_v2.patch) at 2017-12-18 17:35:52 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (0003_add_nowait_vacuum_option_v1.patch) at 2017-12-05 16:52:40 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
Change RangeVarGetRelidExtended() to take flags argument?
First at 2018-03-06 00:53:49 by Andres Freund <andres at anarazel.de>
Latest at 2018-04-02 15:04:16 by "Bossart, Nathan" <bossartn at amazon.com>
Latest attachment (v2-0001-Combine-options-for-RangeVarGetRelidExtended-into.patch) at 2018-03-30 17:08:26 from "Bossart, Nathan" <bossartn at amazon.com>
    Attachment (v2-0001-Combine-options-for-RangeVarGetRelidExtended-into.patch) at 2018-03-30 17:08:26 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (v1-0001-Combine-options-for-RangeVarGetRelidExtended-into.patch) at 2018-03-22 15:45:23 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
Add SKIP LOCKED to VACUUM and ANALYZE
First at 2018-06-13 20:29:12 by "Bossart, Nathan" <bossartn at amazon.com>
Latest at 2018-10-04 01:32:47 by "Bossart, Nathan" <bossartn at amazon.com>
Latest attachment (vacuum-skip-locked-v11.patch) at 2018-10-03 16:20:42 from "Bossart, Nathan" <bossartn at amazon.com>
    Attachment (vacuum-skip-locked-v11.patch) at 2018-10-03 16:20:42 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (vacuum-skip-locked-v10.patch) at 2018-10-02 02:22:42 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (vacuum-open-refactor.patch) at 2018-09-27 07:51:52 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v9-0007-Open-up-VACOPT_SKIP_LOCKED-to-users.patch) at 2018-09-05 15:24:21 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (0001-Refactor-logging-logic-for-skipped-relations-in-VACU.patch) at 2018-07-24 17:21:25 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
    Attachment (0001-Refactor-ClusterStmt-to-handle-more-options.patch) at 2018-07-23 03:10:58 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v8-0001-Add-skip_locked-argument-to-find_inheritance_chil.patch) at 2018-06-13 20:29:12 from "Bossart, Nathan" <bossartn at amazon.com> (Patch: Yes)
History
When Who What
2018-10-04 01:46:46 Michael Paquier (michael-kun) Closed in commitfest 2018-11 with status: Committed
2018-10-04 01:46:46 Michael Paquier (michael-kun) Changed committer to michael-kun
2018-10-02 11:34:46 Nathan Bossart (bossartn) New status: Needs review
2018-09-30 12:55:04 Michael Paquier (michael-kun) New status: Waiting on Author
2018-09-30 12:54:58 Michael Paquier (michael-kun) Closed in commitfest 2018-09 with status: Moved to next CF
2018-09-30 12:54:51 Michael Paquier (michael-kun) New status: Needs review
2018-09-27 07:52:16 Michael Paquier (michael-kun) New status: Waiting on Author
2018-09-05 15:28:46 Nathan Bossart (bossartn) New status: Needs review
2018-08-10 22:55:14 Andrew Dunstan (adunstan) New status: Waiting on Author
2018-08-10 22:40:55 Andrew Dunstan (adunstan) Closed in commitfest 2018-07 with status: Moved to next CF
2018-08-10 22:40:50 Andrew Dunstan (adunstan) New status: Needs review
2018-07-17 06:23:28 Michael Paquier (michael-kun) New status: Waiting on Author
2018-06-28 08:03:59 Masahiko Sawada (masahikosawada) Added masahikosawada as reviewer
2018-06-13 20:30:40 Nathan Bossart (bossartn) Attached mail thread 9EF7EBE4-720D-4CF1-9D0E-4403D7E92990@amazon.com
2018-04-06 20:23:53 Nathan Bossart (bossartn) Closed in commitfest 2018-03 with status: Moved to next CF
2018-04-05 20:32:34 Nathan Bossart (bossartn) New status: Needs review
2018-04-05 19:30:19 Nathan Bossart (bossartn) Changed name to Add SKIP LOCKED option to VACUUM and ANALYZE
2018-04-02 15:05:08 Nathan Bossart (bossartn) New status: Waiting on Author
2018-03-30 00:17:32 Andres Freund (andresfreund) Attached mail thread 20180306005349.b65whmvj7z6hbe2y@alap3.anarazel.de
2018-03-06 15:50:03 Nathan Bossart (bossartn) New status: Needs review
2018-03-04 00:13:00 Andres Freund (andresfreund) New status: Waiting on Author
2018-02-06 21:58:14 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2018-01 with status: Moved to next CF
2018-01-10 23:15:17 Michael Paquier (michael-kun) New status: Ready for Committer
2018-01-10 17:38:42 Nathan Bossart (bossartn) New status: Needs review
2018-01-09 05:47:34 Michael Paquier (michael-kun) New status: Waiting on Author
2018-01-09 05:47:31 Michael Paquier (michael-kun) Changed reviewers to Michael Paquier (michael-kun)
2017-12-05 17:00:51 Nathan Bossart (bossartn) Changed topic to SQL Commands
2017-12-05 16:56:40 Nathan Bossart (bossartn) Changed authors to Nathan Bossart (bossartn)
2017-12-05 16:56:30 Nathan Bossart (bossartn) Attached mail thread 20171201160907.27110.74730@wrigleys.postgresql.org
2017-12-05 16:56:30 Nathan Bossart (bossartn) Created patch record
Edit