Re: [HACKERS] Vacuum: allow usage of more than 1GB of work mem
Claudio Freire <klaussfreire@gmail.com>
From: Claudio Freire <klaussfreire@gmail.com>
To: Stephen Frost <sfrost@snowman.net>
Cc: Michael Paquier <michael.paquier@gmail.com>,
Daniel Gustafsson <daniel@yesql.se>, Andres Freund <andres@anarazel.de>, Masahiko Sawada <sawada.mshk@gmail.com>, Anastasia Lubennikova <a.lubennikova@postgrespro.ru>, Anastasia Lubennikova <lubennikovaav@gmail.com>,
PostgreSQL-Dev <pgsql-hackers@postgresql.org>
Date: 2018-01-17T20:17:29Z
Lists: pgsql-hackers
Attachments
- 0001-Vacuum-allow-using-more-than-1GB-work-mem-v14.patch (text/x-patch) patch v14-0001
- 0003-Vacuum-free-dead-tuples-array-as-early-as-possible-v7.patch (text/x-patch) patch v7-0003
On Wed, Jan 17, 2018 at 5:02 PM, Claudio Freire <klaussfreire@gmail.com> wrote: > > > On Sat, Jan 6, 2018 at 7:35 PM, Stephen Frost <sfrost@snowman.net> wrote: > >> Greetings, >> >> * Michael Paquier (michael.paquier@gmail.com) wrote: >> > On Mon, Dec 4, 2017 at 2:38 PM, Claudio Freire <klaussfreire@gmail.com> >> wrote: >> > > They did apply at the time, but I think major work on vacuum was >> > > pushed since then, and also I was traveling so out of reach. >> > > >> > > It may take some time to rebase them again. Should I move to needs >> > > review myself after that? >> > >> > Sure, if you can get into this state, please feel free to update the >> > status of the patch yourself. >> >> We're now over a month since this status update- Claudio, for this to >> have a chance during this commitfest to be included (which, personally, >> I think would be great as it solves a pretty serious issue..), we really >> need to have it be rebased and updated. Once that's done, as Michael >> says, please change the patch status back to 'Needs Review'. >> > > Sorry, had tons of other stuff that took priority. > > I'll get to rebase this patch now. > > > Huh. That was simpler than I thought. Attached rebased versions.
Commits
-
Prefetch blocks during lazy vacuum's truncation scan
- 7e26e02eec90 10.0 landed
-
Explain unaccounted for space in pgstattuple.
- 71f996d22125 10.0 cited