On Tue, Mar 23, 2004 at 11:21:39 -0500,
Phil Endecott <spam_from_postgresql_lists(at)chezphil(dot)org> wrote:
> Does anyone have any suggestions about how to do this? I'd like a nice
> general technique that works for all possible subqueries, as my current
> composition with INTERSECT does.
One adjustment you might make is using INTERSECT ALL if you know there
can't be duplicates. Then time won't be wasted trying to remove duplicates.
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2004-03-23 17:17:40|
|Subject: Re: Optimisation of INTERSECT expressions|
|Previous:||From: Phil Endecott||Date: 2004-03-23 16:21:39|
|Subject: Re: Optimisation of INTERSECT expressions |