Hi! Sorry to post to this mailing list, but I could not find many tips working
around HashAggregate issues.
In a research project involving text repetition analysis (on top of public
documents)
I have a VirtualMachine (CPU AMD Epyc 7502P, 128GB RAM, 12TB HDD, 2TB SSD),
running postgres 12.12 (Ub
On Fri, Dec 16, 2022 at 03:24:17PM +, João Paulo Luís wrote:
> Hi! Sorry to post to this mailing list, but I could not find many tips
> working around HashAggregate issues.
>
> In a research project involving text repetition analysis (on top of public
> documents)
> I have a VirtualMachine (
he sender immediately if you have received this message by
mistake.
Thank you for your cooperation.
De: Justin Pryzby
Enviado: 16 de dezembro de 2022 16:06
Para: João Paulo Luís
Cc: pgsql-performance@lists.postgresql.org
Assunto: Re: Postgres12 looking for possible
On Sun, 18 Dec 2022 at 23:44, João Paulo Luís wrote:
> Meanwhile, as a one-time workaround I've disabled the hashagg algorithm,
The way the query planner determines if Hash Aggregate's hash table
will fit in work_mem or not is based on the n_distinct estimate of the
columns being grouped on. You
the intended recipient, any
disclosure, copying, or distribution of the message, or any action or omission
taken by you in reliance on it is prohibited.
Please contact the sender immediately if you have received this message by
mistake.
Thank you for your cooperation.
__________