Add SKIP LOCKED option to VACUUM and ANALYZE

Edit
ID 1399
Title Add SKIP LOCKED option to VACUUM and ANALYZE
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic SQL Commands
Tags
Created 2017-12-05 16:56:30
Last modified 2018-10-04 01:46:46 (7 years ago)
Latest email 2018-10-04 01:32:47 (7 years ago)
Status
2018-11 (2018-11-01 – 2018-11-30): Committed
2018-09 (2018-09-01 – 2018-09-30): Moved to different CF
2018-07 (2018-07-01 – 2018-07-31): Moved to different CF
2018-03 (2018-03-01 – 2018-03-31): Moved to different CF
2018-01 (2018-01-01 – 2018-01-31): Moved to different 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