Postgres Pro
Downloads
Home   >   mailing lists

Re: Time to increase hash_mem_multiplier default? - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Time to increase hash_mem_multiplier default?
Date
Msg-id CAH2-Wzkwn2pVbThrgfWeH6_TC5pA80mZ1LjVi_Q65bb9-o=vgw@mail.gmail.com
Whole thread Raw
In response to Time to increase hash_mem_multiplier default?  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Kasahara Tatsuhito
Date:
Subject: Re: Small and unaffected typo in pg_logical_slot_get_changes_guts()
Next
From: Robert Haas
Date:
Subject: Re: do only critical work during single-user vacuum?