Re: autovacuum maintenance_work_mem - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: autovacuum maintenance_work_mem
Date
Msg-id 4CE2BD58.5050801@enterprisedb.com
Whole thread Raw
In response to autovacuum maintenance_work_mem  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
On 16.11.2010 18:12, Alvaro Herrera wrote:
> Thoughts?

Sounds reasonable, but you know what would be even better? Use less 
memory in vacuum, so that it doesn't become an issue to begin with. 
There was some discussion on that back in 2007 
(http://archives.postgresql.org/pgsql-hackers/2007-02/msg01814.php). 
That seems like low-hanging fruit, it should be simple to switch to more 
compact representation. I believe you could easily more than half the 
memory consumption in typical scenarios.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Explain analyze getrusage tracking
Next
From: Robert Haas
Date:
Subject: Re: autovacuum maintenance_work_mem