Postgres Pro
Downloads
Home   >   mailing lists

Re: When do vacuumed pages/tuples become available for reuse? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: When do vacuumed pages/tuples become available for reuse?
Date
Msg-id 20190411140938.GA22402@alvherre.pgsql
Whole thread Raw
In response to Re: When do vacuumed pages/tuples become available for reuse?  (rihad <rihad@mail.ru>)
Responses Re: When do vacuumed pages/tuples become available for reuse?  (rihad <rihad@mail.ru>)
List pgsql-general
Tree view 
On 2019-Apr-11, rihad wrote:

> Thanks! Our autovacuum_work_mem = 1GB, so this probably means any space
> would be available for reuse only at the end of the vacuum? Are there any
> downsides in decreasing it to, say, 64MB? I see only pluses )

Yes, each vacuum will take longer and will use much more I/O.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: rihad
Date:
Subject: Re: When do vacuumed pages/tuples become available for reuse?
Next
From: rihad
Date:
Subject: Re: When do vacuumed pages/tuples become available for reuse?