Postgres Pro
Downloads
Home   >   mailing lists

Re: Index isn't used during a join. - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: Index isn't used during a join.
Date
Msg-id 20060111170645.GA58041@winnie.fuhr.org
Whole thread Raw
In response to Re: Index isn't used during a join.  (Robert Creager <Robert_Creager@LogicalChaos.org>)
List pgsql-performance
Tree view 
On Wed, Jan 11, 2006 at 08:02:37AM -0700, Robert Creager wrote:
> The query is wrong as stated, as it won't work when the interval
> crosses a year boundary, but it's a stop gap for now.

Yeah, I realized that shortly after I posted the original and posted
a correction.

http://archives.postgresql.org/pgsql-performance/2006-01/msg00104.php

--
Michael Fuhr

pgsql-performance by date:

Previous
From: Pallav Kalva
Date:
Subject: Re: Postgres8.0 planner chooses WRONG plan
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Improving Inner Join Performance