| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Peter Geoghegan <pg(at)bowt(dot)ie>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, 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>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Default setting for enable_hashagg_disk (hash_mem) |
| Date: | 2020-07-06 10:29:29 |
| Message-ID: | CAA4eK1JVUwfne2A3mERR5rLhkWxsAyJhxH-VLY5Wfuz5GT+QJg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers |
On Sun, Jul 5, 2020 at 2:24 AM Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
>
> On Sat, 2020-07-04 at 14:49 +0530, Amit Kapila wrote:
> > > We don't even have a user report yet of a
> > > regression compared to PG 12, or one that can't be fixed by
> > > increasing
> > > work_mem.
> > >
> >
> > Yeah, this is exactly the same point I have raised above. I feel we
> > should wait before designing any solution to match pre-13 behavior
> > for
> > hashaggs to see what percentage of users face problems related to
> > this
> > and how much is a problem for them to increase work_mem to avoid
> > regression.
>
> I agree that it's good to wait for actual problems. But the challenge
> is that we can't backport an added GUC.
>
Is it because we won't be able to edit existing postgresql.conf file
or for some other reasons?
--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2020-07-07 03:48:41 | Re: Default setting for enable_hashagg_disk (hash_mem) |
| Previous Message | Peter Geoghegan | 2020-07-05 23:47:40 | Re: Default setting for enable_hashagg_disk (hash_mem) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yuzuko | 2020-07-06 10:35:37 | Re: Autovacuum on partitioned table (autoanalyze) |
| Previous Message | Amit Kapila | 2020-07-06 09:39:19 | Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions |