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