Re: Index isn't used during a join.

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
Cc: PGPerformance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index isn't used during a join.
Date: 2006-01-11 17:06:45
Message-ID: 20060111170645.GA58041@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-01-11 18:25:45 Re: Improving Inner Join Performance
Previous Message Pallav Kalva 2006-01-11 16:44:58 Re: Postgres8.0 planner chooses WRONG plan