Re: Out of Memory - 8.2.4

Erik Jones escribió:
> On Aug 28, 2007, at 4:33 PM, Marko Kreen wrote:
>
>> I've experienced something similar.  The reason turned out to be
>> combination of overcommit=off, big maint_mem and several parallel
>> vacuums for fast-changing tables.  Seems like VACUUM allocates
>> full maint_mem before start, whatever the actual size of the table.
>>
>> Fix was to put "set maint_mem=32M" before small vacuums and
>> serialize some of them.
>
> I'm not sure about the OP but I know that we just run autovacuum so no
> problem with parallel vacuums.  In addition, Solaris doesn't have
> overcommit.

Note that as of 8.3 you will have vacuums running in parallel with
autovac ... 3 in the default config.  So keep an eye on that
maintenance_work_mem setting.

--
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"XML!" Exclaimed C++.  "What are you doing here? You're not a programming
language."
"Tell that to the people who use me," said XML.