Re: Default setting for enable_hashagg_disk - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Default setting for enable_hashagg_disk
Date
Msg-id 99b047386525b87df1e611335c2e57a6cdef346b.camel@j-davis.com
Whole thread Raw
In response to Re: Default setting for enable_hashagg_disk  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Default setting for enable_hashagg_disk  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Wed, 2020-07-08 at 10:00 -0400, Stephen Frost wrote:
> That HashAgg previously didn't care that it was going wayyyyy over
> work_mem was, if anything, a bug.

I think we all agree about that, but some people may be depending on
that bug.

>   Inventing new GUCs late in the
> cycle like this under duress seems like a *really* bad idea.

Are you OK with escape-hatch GUCs that allow the user to opt for v12
behavior in the event that they experience a regression?

The one for the planner is already there, and it looks like we need one
for the executor as well (to tell HashAgg to ignore the memory limit
just like v12).

Regards,
    Jeff Davis





pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: OpenSSL 3.0.0 compatibility
Next
From: Fabien COELHO
Date:
Subject: Re: pgbench - add pseudo-random permutation function