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

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.