Re: Scrub one large table against another

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: brendan(dot)curran(at)gmail(dot)com
Cc: Pg Performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Scrub one large table against another
Date: 2006-10-11 02:50:19
Message-ID: 15751.1160535019@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Brendan Curran <brendan(dot)curran(at)gmail(dot)com> writes:
> So much time is being spent in the Unique and Sort leaves... I would
> think that it wouldn't need to do the unique portion, since there is no
> DISTINCT clause...

There's nothing in that query suggesting that suppress.email is unique.
If you know that it is, try using a plain join instead of an IN.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Brian Herlihy 2006-10-11 03:57:58 Re: Simple join optimized badly?
Previous Message Tom Lane 2006-10-11 02:38:29 Re: Simple join optimized badly?