On Mon, Feb 25, 2008 at 8:45 AM, Matthew <matthew(at)flymine(dot)org> wrote:
> On Fri, 22 Feb 2008, Kynn Jones wrote:
> > Hi. I'm trying to optimize...
> > (Q1) SELECT a1.word, a2.word
> > FROM T a1 JOIN T a2 USING ( zipk )
> > WHERE a1.type = <int1>
> > AND a2.type = <int2>;
> Okay, try this:
> Create an index on T(type, zipk), and then CLUSTER on that index...
This is just GREAT!!! It fits the problem to a tee.
Many, many thanks!
Also, including zipk in the index is a really nice extra boost. (If you
hadn't mentioned it I would have just settled for clustering only on
Thanks for that also!
In response to
pgsql-performance by date
|Next:||From: Matthew||Date: 2008-02-25 16:56:32|
|Subject: Re: Q on views and performance|
|Previous:||From: Joel Stevenson||Date: 2008-02-25 16:48:20|
|Subject: Re: LISTEN / NOTIFY performance in 8.3|