Re: Time to increase hash_mem_multiplier default?

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Time to increase hash_mem_multiplier default?
Дата
Msg-id CAH2-Wzkwn2pVbThrgfWeH6_TC5pA80mZ1LjVi_Q65bb9-o=vgw@mail.gmail.com
обсуждение исходный текст
Ответ на Time to increase hash_mem_multiplier default?  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
Дерево обсуждения 
On Tue, Feb 15, 2022 at 8:17 AM Justin Pryzby <pryzby@telsasoft.com> wrote:
> The only reason not to is that a single-node hash-aggregate plan will now use
> 2x work_mem.  Which won't make sense to someone who doesn't deal with
> complicated plans (and who doesn't know that work_mem is per-node and can be
> used multiplicitively).

Hearing no objections, I pushed a commit to increase the default to 2.0.

Thanks
--
Peter Geoghegan

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

Предыдущее
От: Kasahara Tatsuhito
Дата:
Сообщение: Re: Small and unaffected typo in pg_logical_slot_get_changes_guts()
Следующее
От: Robert Haas
Дата:
Сообщение: Re: do only critical work during single-user vacuum?