Re: using a lot of maintenance_work_mem

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: using a lot of maintenance_work_mem
Дата
Msg-id 1297891452.7986.2.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: using a lot of maintenance_work_mem  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: using a lot of maintenance_work_mem  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Список pgsql-hackers
On mån, 2011-02-14 at 10:11 -0500, Tom Lane wrote:
> But before expending time on that, I'd want to see some evidence that
> it's actually helpful for production situations.  I'm a bit dubious
> that you're going to gain much here.

If you want to build an index on a 500GB table and you have 1TB RAM,
then being able to use >>1GB maintenance_work_mem can only be good, no?




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

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Usability tweaks for extension commands
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Add support for logging the current role