Re: HashAgg degenerate case - Mailing list pgsql-bugs

From David Rowley
Subject Re: HashAgg degenerate case
Date
Msg-id CAApHDvr3byTEhJ+yZb91t3OqAHtsyADUea2Xe2zCnw+G4k0RpA@mail.gmail.com
Whole thread Raw
List pgsql-bugs
On Wed, 6 Nov 2024 at 14:00, Jeff Davis <pgsql@j-davis.com> wrote:
> Fixing it seems fairly easy though: we just need to completely destroy
> the hash table each time and recreate it. Something close to the
> attached patch (rough).

I don't think it could be that exactly though as that could lead to
JIT compilation over and over again from the following chain of
function calls: build_hash_tables() -> build_hash_table() ->
BuildTupleHashTableExt() -> ExecBuildGroupingEqual() ->
ExecReadyExpr() -> jit_compile_expr()

David



pgsql-bugs by date:

Previous
From: Christoph Berg
Date:
Subject: Re: BUG #18655: APT repository shell script doesn't work
Next
From: PG Bug reporting form
Date:
Subject: BUG #18690: A count function returns wrong value when using FDW