Re: autovacuum maintenance_work_mem

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: autovacuum maintenance_work_mem
Дата
Msg-id 4CE2BD58.5050801@enterprisedb.com
обсуждение исходный текст
Ответ на autovacuum maintenance_work_mem  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Explain analyze getrusage tracking
Следующее
От: Robert Haas
Дата:
Сообщение: Re: autovacuum maintenance_work_mem