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

Edit
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 (5 years, 5 months ago)
Latest email 2018-10-02 01:43:03 (5 years, 5 months 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 Heikki Linnakangas (heikki), Masahiko Sawada (masahikosawada), Anastasia Lubennikova (lubennikovaav), Aleksander Alekseev (a.alekseev), Alexey Chernyshov (alexey-chernyshov)Become reviewer
Committer
Links
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