Marko Kreen escribió:
> 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.
Hmm. Maybe we should have VACUUM estimate how much is the maximum
amount of memory that would be used, given the size of the table, and
allocate only that much.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support