On Tue, Nov 20, 2012 at 1:27 AM, Pavel Stehule <pavel.stehule@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
