RE: Postgres12 looking for possible HashAggregate issue workarounds?

2022-12-19 Thread João Paulo Luís
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. __

RE: Postgres12 looking for possible HashAggregate issue workarounds?

2022-12-18 Thread João Paulo Luís
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

Postgres12 looking for possible HashAggregate issue workarounds?

2022-12-16 Thread João Paulo Luís
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