Re: [GENERAL] autovacuum out of memory errors

2013-09-11 Thread Kevin Grittner
tim truman wrote: > [ memory usage map ] There doesn't seem to be any memory context using an unusually large amount of RAM. >  522f9128.1151 ERROR:  out of memory >  522f9128.1151 DETAIL:  Failed on request of size 336150396. >  522f9128.1151 CONTEXT:  automatic vacuum of table "client.public

[GENERAL] autovacuum out of memory errors

2013-09-11 Thread tim truman
Hi, Starting this morning I have been getting out of memory errors from the postgres autovacuum process. I have searched through previous similar questions but not found anything other than suggestions to reduce either 'shared_buffers' or 'maintenance_work_mem' but these seem very instance specifi