Re: Optimisation of INTERSECT expressions - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: Optimisation of INTERSECT expressions
Date
Msg-id 20040323170500.GA25181@wolff.to
Whole thread Raw
In response to Re: Optimisation of INTERSECT expressions  ("Phil Endecott" <spam_from_postgresql_lists@chezphil.org>)
Responses Re: Optimisation of INTERSECT expressions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Tue, Mar 23, 2004 at 11:21:39 -0500,
  Phil Endecott <spam_from_postgresql_lists@chezphil.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.

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Benchmarking postgres on Solaris/Linux
Next
From: Josh Berkus
Date:
Subject: Re: Optimisation of INTERSECT expressions