Re: When do vacuumed pages/tuples become available for reuse?

From: rihad <rihad(at)mail(dot)ru>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: When do vacuumed pages/tuples become available for reuse?
Date: 2019-04-11 14:13:28
Message-ID: 27e4bf5f-da7f-e355-424b-83b57c1494b5@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/11/2019 06:09 PM, Alvaro Herrera wrote:
> 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.
>
I see, thanks.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-04-11 14:20:15 Re: When do vacuumed pages/tuples become available for reuse?
Previous Message Alvaro Herrera 2019-04-11 14:09:38 Re: When do vacuumed pages/tuples become available for reuse?