Good to know, thanks for the response.
Ben
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, October 02, 2015 4:16 PM
To: Ben Primrose
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Long-running and non-finishing VACUUM ANALYZE on
large table
Ben Primrose <bprimrose(at)tracelink(dot)com> writes:
> Tom, how'd you determine the maintenance_work_mem?
From the numbers of tuples shown as being removed in each index pass.
The work-mem usage is 6 bytes per TID, and it'll stop and do an index pass
once we get close to full.
regards, tom lane