Re: Auto-tuning work_mem and maintenance_work_mem

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Auto-tuning work_mem and maintenance_work_mem
Дата
Msg-id 1382025314.97411.YahooMailNeo@web162906.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: Auto-tuning work_mem and maintenance_work_mem  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Auto-tuning work_mem and maintenance_work_mem  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:

> I still think my previous proposal of increasing the defaults for
> work_mem and maintenance_work_mem by 4X would serve many more
> people well than it would serve poorly.  I haven't heard anyone
> disagree with that notion.  Does anyone disagree?  Should we do
> it?

I think that it makes sense to do that.  Those are still reasonable
defaults for a machine with 2GB of RAM, maybe even with less.
We're talking about putting this only in a release that will come
out in 2014.  How many machines used for a database server that new
will have less than that?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Rework SSL renegotiation code
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Auto-tuning work_mem and maintenance_work_mem