From: | Claudio Freire <klaussfreire(at)gmail(dot)com> |
---|---|
To: | PostgreSQL-Dev <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Vacuum: allow usage of more than 1GB of work mem |
Date: | 2016-09-03 03:25:37 |
Message-ID: | CAGTBQpbDCaR6vv9=scXzuT8fSbckf=a3NgZdWFWZbdVugVht6Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
The attached patch allows setting maintainance_work_mem or
autovacuum_work_mem higher than 1GB (and be effective), by turning the
allocation of the dead_tuples into a huge allocation.
This results in fewer index scans for heavily bloated tables, and
could be a lifesaver in many situations (in particular, the situation
I'm living right now in production, where we don't have enough room
for a vacuum full, and have just deleted 75% of a table to make room
but have to rely on regular lazy vacuum to free the space).
The patch also makes vacuum free the dead_tuples before starting
truncation. It didn't seem necessary to hold onto it beyond that
point, and it might help give the OS more cache, especially if work
mem is configured very high to avoid multiple index scans.
Tested with pgbench scale 4000 after deleting the whole
pgbench_accounts table, seemed to work fine.
Attachment | Content-Type | Size |
---|---|---|
0001-Vacuum-allow-using-more-than-1GB-work-mem.patch | text/x-patch | 2.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2016-09-03 04:29:32 | Re: Issue with bgworker, SPI and pgstat_report_stat |
Previous Message | Tomas Vondra | 2016-09-03 02:04:27 | Re: less expensive pg_buffercache on big shmem |