Good to know, thanks for the response. Ben -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Friday, October 02, 2015 4:16 PM To: Ben Primrose Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Long-running and non-finishing VACUUM ANALYZE on large table Ben Primrose <bprimrose@xxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
