From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Jeff Davis <pgsql@j-davis.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: Justin Pryzby <pryzby@telsasoft.com>
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: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Default setting for enable_hashagg_disk (hash_mem)
Date: Tue, 7 Jul 2020 16:18:21 -0400
Message-ID: <20200707201821.GA24503@alvherre.pgsql> (raw)
In-Reply-To: <CAA4eK1K-Uc1UFP5PKZEZYGG3cnnQTksXGBgnU4BBUTVx+Y43Fw@mail.gmail.com>
On 2020-Jul-07, Amit Kapila wrote:
> I don't think this is true. We seem to have introduced three new guc
> variables in a 9.3.3 minor release.
Yeah, backporting GUCs is not a big deal. Sure, the GUC won't appear in
postgresql.conf files generated by initdb prior to the release that
introduces it. But users that need it can just edit their .confs and
add the appropriate line, or just do ALTER SYSTEM after the minor
upgrade. For people that don't need it, it would have a reasonable
default (probably work_mem, so that behavior doesn't change on the minor
upgrade).
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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: alvherre@2ndquadrant.com, amit.kapila16@gmail.com, pgsql@j-davis.com, bruce@momjian.us, pg@bowt.ie, pryzby@telsasoft.com, 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: <20200707201821.GA24503@alvherre.pgsql>
* 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