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

Claudio Freire <klaussfreire@gmail.com>

View thread View on postgr.es

From: Claudio Freire <klaussfreire@gmail.com>

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Cc: Claudio Freire <klaussfreire@gmail.com>

Date: 2018-04-03T14:20:11Z

Lists: pgsql-hackers

Attachments

0001-Vacuum-allow-using-more-than-1GB-work-mem-v20.patch (text/x-patch) patch v20-0001
0003-Vacuum-free-dead-tuples-array-as-early-as-possible-v11.patch (text/x-patch) patch v11-0003

On Tue, Apr 3, 2018 at 11:09 AM, Claudio Freire <klaussfreire@gmail.com> wrote:
> On Tue, Apr 3, 2018 at 11:06 AM, Claudio Freire <klaussfreire@gmail.com> wrote:
>> I didn't receive your comment, I just saw it. Nevertheless, I rebased the patches a while ago just because I noticed they didn't apply anymore in cputube, and they still seem to apply.
>
> Sorry, that is false.
>
> They appear green in cputube, so I was confident they did apply, but I
> just double-checked on a recent pull and they don't. I'll rebase them
> shortly.


Ok, rebased patches attached

Commits

Prefetch blocks during lazy vacuum's truncation scan
- 7e26e02eec90 10.0 landed
Explain unaccounted for space in pgstattuple.
- 71f996d22125 10.0 cited