Vacuum: allow usage of more than 1GB of work mem

Edit

ID 844

Title Vacuum: allow usage of more than 1GB of work mem

Topic Performance

Created 2016-10-26 22:31:09

Last modified 2018-10-02 01:43:11 (6 years, 1 month ago)

Latest email 2018-10-02 01:43:03 (6 years, 1 month ago)

Status

2018-09: Returned with feedback

2018-07: Moved to next CF

2018-03: Moved to next CF

2018-01: Moved to next CF

2017-11: Moved to next CF

2017-09: Moved to next CF

2017-03: Moved to next CF

2017-01: Moved to next CF

2016-11: Moved to next CF

Target version

Authors Heikki Linnakangas (heikki), Claudio Freire (klaussfreire)

Reviewers Masahiko Sawada (masahikosawada), Anastasia Lubennikova (lubennikovaav), Alexey Chernyshov (alexey-chernyshov), Aleksander Alekseev (a.alekseev), Heikki Linnakangas (heikki)Become reviewer

Committer

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/844
git checkout commitfest/cf/844

Emails

Vacuum: allow usage of more than 1GB of work mem

First at 2016-09-03 03:25:37 by Claudio Freire <klaussfreire at gmail.com>
Latest at 2018-10-02 01:43:03 by Michael Paquier <michael at paquier.xyz>
Latest attachment (vacuumbenchone.sh) at 2018-04-06 13:42:17 from Heikki Linnakangas <hlinnaka at iki.fi>

    Attachment (vacuumbenchone.sh) at 2018-04-06 13:42:17 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: No)
    Attachment (vacuum-tidmap-2.patch) at 2018-04-06 13:39:21 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (vacuumbench.sh) at 2018-04-05 22:59:59 from Claudio Freire <klaussfreire at gmail.com> (Patch: No)
    Attachment (vacuum-tidmap-1.patch) at 2018-04-05 20:02:09 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (0001-Vacuum-allow-using-more-than-1GB-work-mem-v20.patch) at 2018-04-03 14:20:11 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0001-Vacuum-allow-using-more-than-1GB-work-mem-v19.patch) at 2018-03-16 21:46:06 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0001-Vacuum-allow-using-more-than-1GB-work-mem-v18.patch) at 2018-02-09 16:05:43 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (unknown_filename) at 2018-02-08 05:44:35 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: No)
    Attachment (0001-Vacuum-allow-using-more-than-1GB-work-mem-v17.patch) at 2018-02-08 00:21:29 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0001-Vacuum-allow-using-more-than-1GB-work-mem-v16.patch) at 2018-02-07 14:36:54 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0003-Vacuum-free-dead-tuples-array-as-early-as-possible-v8.patch) at 2018-02-06 13:41:22 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0001-Vacuum-allow-using-more-than-1GB-work-mem-v14.patch) at 2018-01-17 20:17:29 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v13.patch) at 2017-10-02 14:02:52 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v12.patch) at 2017-07-14 01:06:52 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v11.patch) at 2017-07-11 16:51:03 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v11.patch) at 2017-07-10 23:04:42 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v10.patch) at 2017-04-20 21:24:13 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v9.patch) at 2017-04-08 02:19:42 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0003-Vacuum-free-dead-tuples-array-as-early-as-possible.patch) at 2017-03-29 01:46:12 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v8.patch) at 2017-02-01 22:55:16 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v7.patch) at 2017-01-31 02:05:28 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v6.patch) at 2017-01-25 20:11:13 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem-v5.patch) at 2017-01-23 16:49:03 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0001-Prefetch-blocks-during-lazy-vacuum-s-truncation-scan.patch) at 2017-01-20 21:25:18 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Vacuum-prefetch-buffers-on-backward-scan-v4.patch) at 2016-12-28 20:43:21 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0001-Vacuum-prefetch-buffers-on-backward-scan-v3.patch) at 2016-12-22 18:18:07 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0002-Vacuum-allow-using-more-than-1GB-work-mem.patch) at 2016-11-17 18:42:55 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (vacuum_bench_results.tar.gz) at 2016-10-26 20:25:23 from Claudio Freire <klaussfreire at gmail.com> (Patch: No)
    Attachment (0001-Vacuum-allow-using-more-than-1GB-work-mem-v2-multiarray.patch) at 2016-09-15 16:16:52 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (vacuum_print_offset_stats.patch) at 2016-09-14 09:45:32 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (0001-Collect-dead-tuple-location-as-a-bitmap.patch) at 2016-09-09 07:04:15 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (vacuum_mem_estimate.v1.patch) at 2016-09-07 12:45:50 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (0002-Vacuum-prefetch-buffers-on-backward-scan.patch) at 2016-09-06 18:25:10 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (0001-Vacuum-allow-using-more-than-1GB-work-mem.patch) at 2016-09-05 19:15:40 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (allow_vacuum_work_mem_gt_1GB.v2.patch) at 2016-09-04 06:46:26 from Simon Riggs <simon at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Vacuum-allow-using-more-than-1GB-work-mem.patch) at 2016-09-03 03:25:37 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)

Annotations

When	Who	Mail	Annotation
2016-11-19 00:13:55	Claudio Freire (klaussfreire)	From Claudio Freire <klaussfreire@gmail.com> at 2016-10-26 20:25:23	V2 - multisegment reap tid implementation
2016-11-19 00:14:25	Claudio Freire (klaussfreire)	From Claudio Freire <klaussfreire@gmail.com> at 2016-11-17 21:54:55	V2b - V2 patch 0002 after pgindent
2017-01-23 16:52:41	Claudio Freire (klaussfreire)	From Claudio Freire <klaussfreire@gmail.com> at 2017-01-23 16:49:03	V5 patch 0002 after lazy_clear_dead_tuples fix and rebase
2017-07-14 06:04:54	Alexey Chernyshov (alexey-chernyshov)	From Claudio Freire <klaussfreire@gmail.com> at 2017-07-11 16:51:03	v11 patch and benchmarking
2017-07-14 06:05:53	Alexey Chernyshov (alexey-chernyshov)	From Claudio Freire <klaussfreire@gmail.com> at 2017-07-14 01:06:52	v12 patch

History

When	Who	What
2018-10-02 01:43:11	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Returned with feedback
2018-08-10 22:48:44	Andrew Dunstan (adunstan)	New status: Waiting on Author
2018-08-10 22:36:28	Andrew Dunstan (adunstan)	Closed in commitfest 2018-07 with status: Moved to next CF
2018-08-10 22:36:21	Andrew Dunstan (adunstan)	New status: Needs review
2018-07-13 20:39:42	Andrew Dunstan (adunstan)	Changed authors to Heikki Linnakangas (heikki), Claudio Freire (klaussfreire)
2018-07-12 22:16:07	Andrew Dunstan (adunstan)	New status: Waiting on Author
2018-06-21 17:33:03	Heikki Linnakangas (heikki)	Added heikki as reviewer
2018-04-10 12:37:14	David Steele (dsteele)	Closed in commitfest 2018-03 with status: Moved to next CF
2018-04-03 14:06:30	Claudio Freire (klaussfreire)	Posted comment with messageid <152276439068.1260.2090297277175952841.pgcf@coridan.postgresql.org>
2018-04-03 14:00:57	Claudio Freire (klaussfreire)	New status: Needs review
2018-03-27 13:20:47	Aleksander Alekseev (a.alekseev)	New status: Waiting on Author
2018-03-27 13:20:42	Aleksander Alekseev (a.alekseev)	Posted comment with messageid <152215684296.14388.9748658189135318405.pgcf@coridan.postgresql.org>
2018-02-06 21:55:04	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2018-01 with status: Moved to next CF
2018-01-22 15:18:51	Aleksander Alekseev (a.alekseev)	Posted review with messageid <151663433193.23710.778013000582044738.pgcf@coridan.postgresql.org>
2018-01-22 15:18:51	Aleksander Alekseev (a.alekseev)	New status: Ready for Committer
2018-01-22 15:11:42	Aleksander Alekseev (a.alekseev)	Added a.alekseev as reviewer
2018-01-22 14:21:22	Aleksander Alekseev (a.alekseev)	New status: Needs review
2017-11-29 01:37:23	Michael Paquier (michael-kun)	New status: Waiting on Author
2017-11-29 01:37:18	Michael Paquier (michael-kun)	Closed in commitfest 2017-11 with status: Moved to next CF
2017-11-29 01:34:14	Michael Paquier (michael-kun)	New status: Needs review
2017-10-01 23:36:35	Daniel Gustafsson (d_gustafsson)	New status: Waiting on Author
2017-10-01 23:36:29	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2017-09 with status: Moved to next CF
2017-07-14 06:08:45	Alexey Chernyshov (alexey-chernyshov)	New status: Ready for Committer
2017-07-14 06:05:53	Alexey Chernyshov (alexey-chernyshov)	Added annotation "v12 patch" to CAGTBQpbwhti4vA4dLbiiRhLbHWQeSzD07dByYEtjvXBP74cvYQ@mail.gmail.com
2017-07-14 06:04:54	Alexey Chernyshov (alexey-chernyshov)	Added annotation "v11 patch and benchmarking" to CAGTBQpZDfN79KJ6szj-9UMpt=L0+rWM9Az2OCX+YxTins=+Xnw@mail.gmail.com
2017-07-12 14:48:43	Alexey Chernyshov (alexey-chernyshov)	New status: Waiting on Author
2017-07-12 13:53:44	Alexey Chernyshov (alexey-chernyshov)	Added alexey-chernyshov as reviewer
2017-07-12 10:20:17	Artur Zakirov (a.zakirov)	New status: Needs review
2017-07-11 11:53:48	Artur Zakirov (a.zakirov)	New status: Waiting on Author
2017-04-08 14:16:56	David Steele (dsteele)	Closed in commitfest 2017-03 with status: Moved to next CF
2017-02-01 05:22:28	Michael Paquier (michael-kun)	Closed in commitfest 2017-01 with status: Moved to next CF
2017-01-23 16:52:41	Claudio Freire (klaussfreire)	Added annotation "V5 patch 0002 after lazy_clear_dead_tuples fix and rebase" to CAGTBQpZe-eKw+m09ZUyqo-8FscQpvpdg9CJgdx=Qa2694mqOdw@mail.gmail.com
2017-01-19 09:34:25	Anastasia Lubennikova (lubennikovaav)	New status: Ready for Committer
2016-12-22 15:15:27	Anastasia Lubennikova (lubennikovaav)	Posted review with messageid <20161222151527.25844.25987.pgcf@coridan.postgresql.org>
2016-12-22 15:15:27	Anastasia Lubennikova (lubennikovaav)	New status: Waiting on Author
2016-12-21 15:45:53	Anastasia Lubennikova (lubennikovaav)	Added lubennikovaav as reviewer
2016-12-05 01:07:51	Haribabu Kommi (haribabu)	Closed in commitfest 2016-11 with status: Moved to next CF
2016-11-19 00:14:25	Claudio Freire (klaussfreire)	Added annotation "V2b - V2 patch 0002 after pgindent" to CAGTBQpbZX5S4QrnB6YP-2Nk+A9bxbaVktzKwsGvMeov3MTgdiQ@mail.gmail.com
2016-11-19 00:13:55	Claudio Freire (klaussfreire)	Added annotation "V2 - multisegment reap tid implementation" to CAGTBQpa6NFGO_6g_y_7zQx8L9GcHDSQKYdo1tGuh791z6PYgEg@mail.gmail.com
2016-11-08 01:43:28	Masahiko Sawada (masahikosawada)	Added masahikosawada as reviewer
2016-10-26 22:32:12	Claudio Freire (klaussfreire)	Changed authors to Claudio Freire (klaussfreire)
2016-10-26 22:31:10	Claudio Freire (klaussfreire)	Attached mail thread CAGTBQpbDCaR6vv9=scXzuT8fSbckf=a3NgZdWFWZbdVugVht6Q@mail.gmail.com
2016-10-26 22:31:09	Claudio Freire (klaussfreire)	Created patch record

Edit