Re: Index isn't used during a join.

From: Michael Fuhr
Subject: Re: Index isn't used during a join.
Date: ,
Msg-id: 20060111170645.GA58041@winnie.fuhr.org
(view: Whole thread, Raw)
In response to: Re: Index isn't used during a join.  (Robert Creager)
List: pgsql-performance

Tree view

Index isn't used during a join.  (Robert Creager, )
 Re: Index isn't used during a join.  (Michael Fuhr, )
  Re: Index isn't used during a join.  (Robert Creager, )
  Re: Index isn't used during a join.  (Robert Creager, )
   Re: Index isn't used during a join.  (Michael Fuhr, )
    Re: Index isn't used during a join.  (Michael Fuhr, )
    Re: Index isn't used during a join.  (Robert Creager, )
     Re: Index isn't used during a join.  (Robert Creager, )
      Re: Index isn't used during a join.  (Michael Fuhr, )
     Re: Index isn't used during a join.  (Tom Lane, )
      Re: Index isn't used during a join.  (Robert Creager, )

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:

From: Tom Lane
Date:
Subject: Re: indexes on primary and foreign keys
From: Michael Fuhr
Date:
Subject: Re: indexes on primary and foreign keys