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.
