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

Heikki Linnakangas <hlinnaka@iki.fi>

View thread View on postgr.es

From: Heikki Linnakangas <hlinnaka@iki.fi>

To: Claudio Freire <klaussfreire@gmail.com>

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

Date: 2018-04-06T13:42:17Z

Lists: pgsql-hackers

Attachments

vacuumbenchone.sh (application/x-shellscript)
vacuumbenchone-results-on-heikkis-laptop.tar.gz (application/gzip)

On 06/04/18 16:39, Heikki Linnakangas wrote:
> Sure. I used the attached script to test this. 

Sorry, I attached the wrong script. Here is the correct one that I used. 
Here are also the results I got from running it

- Heikki

Commits

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