Re: Vacuum: allow usage of more than 1GB of work mem
Claudio Freire <klaussfreire@gmail.com>
From: Claudio Freire <klaussfreire@gmail.com>
To: Anastasia Lubennikova <lubennikovaav@gmail.com>
Cc: PostgreSQL-Dev <pgsql-hackers@postgresql.org>
Date: 2016-12-22T18:18:07Z
Lists: pgsql-hackers
Attachments
- 0001-Vacuum-prefetch-buffers-on-backward-scan-v3.patch (text/x-patch) patch v3-0001
- 0002-Vacuum-allow-using-more-than-1GB-work-mem-v3.patch (text/x-patch) patch v3-0002
On Thu, Dec 22, 2016 at 12:22 PM, Claudio Freire <klaussfreire@gmail.com> wrote: > On Thu, Dec 22, 2016 at 12:15 PM, Anastasia Lubennikova > <lubennikovaav@gmail.com> wrote: >> The following review has been posted through the commitfest application: >> make installcheck-world: tested, failed >> Implements feature: not tested >> Spec compliant: not tested >> Documentation: not tested >> >> Hi, >> I haven't read through the thread yet, just tried to apply the patch and run tests. >> And it seems that the last attached version is outdated now. It doesn't apply to the master >> and after I've tried to fix merge conflict, it segfaults at initdb. > > > I'll rebase when I get some time to do it and post an updated version Attached rebased patches. I called them both v3 to be consistent. I'm not sure how you ran it, but this works fine for me: ./configure --enable-debug --enable-cassert make clean make check ... after a while ... ======================= All 168 tests passed. ======================= I reckon the above is equivalent to installcheck, but doesn't require sudo or actually installing the server, so installcheck should work assuming the install went ok.
Commits
-
Prefetch blocks during lazy vacuum's truncation scan
- 7e26e02eec90 10.0 landed
-
Explain unaccounted for space in pgstattuple.
- 71f996d22125 10.0 cited