On Tue, Nov 20, 2012 at 1:27 AM, Pavel Stehule wrote:
> Hello
>
> HashSetOp is memory expensive operation, and should be problematic
> when statistic estimation is bad.
>
> Try to rewritre this query to JOIN
or, 'WHERE NOT EXISTS'. if 41 seconds seems like it's too long, go
ahead and post that
Hello
HashSetOp is memory expensive operation, and should be problematic
when statistic estimation is bad.
Try to rewritre this query to JOIN
Regards
Pavel Stehule
2012/11/15 Antti Jokipii :
> Hi
>
> I tried to run quite simple query. For some reason query took lots of
> memory, more than 6GB.
Hi
I tried to run quite simple query. For some reason query took lots of
memory, more than 6GB.
System start swapping, so I canceled it after 4 minutes. There were no
other queries in same time.
If I I understood my config correctly that is more than it should be. Is it
bug or is there some other
