Add SKIP LOCKED option to VACUUM and ANALYZE

Edit

ID 1399

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 (6 years, 1 month ago)

Latest email 2018-10-04 01:32:47 (6 years, 1 month 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 CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/1399
git checkout commitfest/cf/1399

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