Re: Default setting for enable_hashagg_disk (hash_mem)

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, David Rowley <dgrowleyml(at)gmail(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Default setting for enable_hashagg_disk (hash_mem)
Date: 2020-07-07 05:02:39
Message-ID: 20200707050239.GE4107@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

On Mon, Jul 06, 2020 at 09:57:08PM -0700, Jeff Davis wrote:
> > I think that we should offer something like hash_mem that can work as
> > a multiple of work_mem, for the reason that Justin mentioned
> > recently.
> > This can be justified as something that more or less maintains some
> > kind of continuity with the old design.
>
> Didn't Justin argue against using a multiplier?
> https://postgr.es/m/20200703024649.GJ4107@telsasoft.com

I recanted.
https://www.postgresql.org/message-id/20200703145620.GK4107@telsasoft.com

--
Justin

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Amit Kapila 2020-07-07 09:50:26 Re: Default setting for enable_hashagg_disk (hash_mem)
Previous Message Jeff Davis 2020-07-07 04:57:08 Re: Default setting for enable_hashagg_disk (hash_mem)

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2020-07-07 05:35:48 Re: A patch for get origin from commit_ts.
Previous Message Jeff Davis 2020-07-07 04:57:08 Re: Default setting for enable_hashagg_disk (hash_mem)