On Tue, Nov 20, 2012 at 1:27 AM, Pavel Stehule <pavel.stehule@gmail.com> 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 plan and maybe that can be optimized.
merlin