pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Justin Pryzby <pryzby@telsasoft.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: David Rowley <dgrowleyml@gmail.com>
Cc: Melanie Plageman <melanieplageman@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Default setting for enable_hashagg_disk (hash_mem)
Date: Tue, 7 Jul 2020 00:02:39 -0500
Message-ID: <20200707050239.GE4107@telsasoft.com> (raw)
In-Reply-To: <06d7cb422c25527fb4e3c5d400018ff725f85313.camel@j-davis.com>
References: <CAH2-WzmD+i1pG6rc1+Cjc4V6EaFJ_qSuKCCHVnH=oruqD-zqow@mail.gmail.com>
	<20200703024649.GJ4107@telsasoft.com>
	<20200703025834.GC26235@momjian.us>
	<20200703030001.GD26235@momjian.us>
	<CAH2-Wzm9AMbCusV=3bxd+K-sMdS1SFJJfWL4aruwNysxuvv6Aw@mail.gmail.com>
	<20200703140808.GE26235@momjian.us>
	<CAA4eK1KfPi6iz0hWxBLZzfVOG_NvOVJL=9UQQirWLpaN=kANTQ@mail.gmail.com>
	<04451034b3652d8bd9f3561c90884c3fc3653901.camel@j-davis.com>
	<CAH2-WzmJA3kxAcUaSL-Vsi_mmsatvL1=Lbi8Mk4PUYVT5xnwCA@mail.gmail.com>
	<06d7cb422c25527fb4e3c5d400018ff725f85313.camel@j-davis.com>

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





view thread (26+ messages)  latest in thread

Message-ID: <20200707050239.GE4107@telsasoft.com>
Permalink:  ../20200707050239.GE4107@telsasoft.com/
Also on:    postgresql.org/message-id/20200707050239.GE4107@telsasoft.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: pryzby@telsasoft.com, pgsql@j-davis.com, pg@bowt.ie, amit.kapila16@gmail.com, bruce@momjian.us, tomas.vondra@2ndquadrant.com, robertmhaas@gmail.com, andres@anarazel.de, dgrowleyml@gmail.com, melanieplageman@gmail.com
  Subject: Re: Default setting for enable_hashagg_disk (hash_mem)
  In-Reply-To: <20200707050239.GE4107@telsasoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox