Block level parallel vacuum

Edit

Title

Topic

Performance

Created

2018-08-27 09:39:40

Last modified

2019-08-01 22:27:34 (2 weeks, 2 days ago)

Latest email

2019-07-20 16:44:53 (4 weeks ago)

Status

2019-09: Needs review

2019-07: Moved to next CF

2019-03: Moved to next CF

2019-01: Moved to next CF

2018-11: Moved to next CF

2018-09: Moved to next CF

Target version

Authors

Masahiko Sawada (masahikosawada)

Reviewers

Haribabu Kommi (haribabu), Sergei Kornilov (melkij)Become reviewer

Committer

Links

Emails

Re: [HACKERS] Block level parallel vacuum

First at 2018-08-14 00:31:23 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest at 2019-07-20 16:44:53 by Sergei Kornilov <sk at zsrv.org>
Latest attachment (v25-0001-Add-parallel-option-to-VACUUM-command.patch) at 2019-06-07 06:26:25 from Masahiko Sawada <sawada.mshk at gmail.com>

    Attachment (v25-0001-Add-parallel-option-to-VACUUM-command.patch) at 2019-06-07 06:26:25 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v24-0002-Add-paralell-P-option-to-vacuumdb-command.patch) at 2019-04-05 21:47:32 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Add-parallel-option-to-VACUUM-command.patch) at 2019-04-05 04:59:36 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Add-parallel-option-to-VACUUM-command.patch) at 2019-04-04 10:23:32 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v21-0001-All-VACUUM-command-options-allow-an-argument.patch) at 2019-03-29 02:26:53 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v20-0001-All-VACUUM-command-options-allow-an-argument.patch) at 2019-03-26 14:31:10 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v19-0001-All-VACUUM-command-options-allow-an-argument.patch) at 2019-03-22 05:02:36 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (vacuum_fix.patch) at 2019-03-19 11:22:33 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Make-vacuum-options-a-Node.patch) at 2019-03-18 02:54:42 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (vacuum-grammer.patch) at 2019-03-14 07:33:18 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (vacuum-options-into-params.patch) at 2019-03-13 21:41:36 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Make-vacuum-options-a-Node.patch) at 2019-03-06 06:22:59 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-parallel-option-to-VACUUM-command.patch) at 2019-02-14 10:14:38 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v14-0002-Add-P-option-to-vacuumdb-command.patch) at 2019-02-02 15:07:53 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Add-parallel-option-to-VACUUM-command.patch) at 2019-01-24 02:14:12 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v12-0002-Add-P-option-to-vacuumdb-command.patch) at 2019-01-18 12:41:42 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Add-parallel-option-to-VACUUM-command.patch) at 2019-01-15 06:59:15 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Add-P-option-to-vacuumdb-command.patch) at 2018-12-28 02:43:44 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v9-0002-Add-P-option-to-vacuumdb-command.patch) at 2018-12-18 07:59:05 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (parallel_vacuum.png) at 2018-11-02 09:26:02 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v8-0001-Publish-some-parallel-heap-scan-functions.patch) at 2018-10-31 00:23:18 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Publish-some-parallel-heap-scan-functions.patch) at 2018-08-14 00:31:23 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)

Annotations

When	Who	Mail	Annotation
2018-08-27 09:41:06	Masahiko Sawada (masahikosawada)	From Masahiko Sawada <sawada.mshk@gmail.com> at 2018-08-14 00:31:23	This patch requires the relation extension lock patch.
2018-12-18 08:01:45	Masahiko Sawada (masahikosawada)	From Masahiko Sawada <sawada.mshk@gmail.com> at 2018-11-26 08:33:55	The scope of this feature is shrinked and now it doesn't matter the relation extension lock problem.

History

When	Who	What
2019-08-01 22:27:34	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-07-20 16:44:57	Sergei Kornilov (melkij)	Added melkij as reviewer
2019-07-20 16:44:53	Sergei Kornilov (melkij)	Posted review with messageid <156364109388.1365.17875067226835232117.pgcf@coridan.postgresql.org>
2019-04-09 03:37:55	Michael Paquier (michael-kun)	Closed in commitfest 2019-03 with status: Moved to next CF
2019-04-08 07:29:58	Kyotaro Horiguchi (horiguti)	New status: Needs review
2019-03-27 05:42:03	Haribabu Kommi (haribabu)	New status: Ready for Committer
2019-02-02 03:02:22	Amit Kapila (amitkapila)	Closed in commitfest 2019-01 with status: Moved to next CF
2019-01-18 05:37:47	Haribabu Kommi (haribabu)	Added haribabu as reviewer
2018-12-18 12:19:36	Dongming Liu (inferyes)	Removed inferyes from reviewers
2018-12-18 12:19:31	Dongming Liu (inferyes)	Added inferyes as reviewer
2018-12-18 08:01:45	Masahiko Sawada (masahikosawada)	Added annotation "The scope of this feature is shrinked and now it doesn't matter the relation extension lock problem." to CAD21AoDhAutvKbQ37Btf4taMVbQaOaSvOpxpLgu814T1-OqYGg@mail.gmail.com
2018-12-18 07:59:38	Masahiko Sawada (masahikosawada)	New status: Needs review
2018-12-01 12:51:25	Dmitry Dolgov (erthalion)	New status: Waiting on Author
2018-12-01 12:51:19	Dmitry Dolgov (erthalion)	Closed in commitfest 2018-11 with status: Moved to next CF
2018-10-01 10:38:53	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Moved to next CF
2018-09-12 10:00:13	Fabien Coelho (calvin)	Changed name to Block level parallel vacuum
2018-08-27 09:41:06	Masahiko Sawada (masahikosawada)	Added annotation "This patch requires the relation extension lock patch." to CAD21AoDTPMgzSkV4E3SFo1CH_x50bf5PqZFQf4jmqjk-C03BWg@mail.gmail.com
2018-08-27 09:39:51	Masahiko Sawada (masahikosawada)	Changed authors to Masahiko Sawada (masahikosawada)
2018-08-27 09:39:40	Masahiko Sawada (masahikosawada)	Attached mail thread CAD21AoDTPMgzSkV4E3SFo1CH_x50bf5PqZFQf4jmqjk-C03BWg@mail.gmail.com
2018-08-27 09:39:40	Masahiko Sawada (masahikosawada)	Created patch record

Edit