Re: Index isn't used during a join.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Robert Creager <Robert_Creager@xxxxxxxxxxxxxxxx>
Subject: Re: Index isn't used during a join.
From: Michael Fuhr <mike@xxxxxxxx>
Date: Wed, 11 Jan 2006 10:06:45 -0700
Cc: PGPerformance <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <20060111080237.66040a61@xxxxxxxxxxxxxxxxxxxxxxxx>
References: <20060109212338.6420af12@xxxxxxxxxxxxxxxxxxxxxxxx> <20060110055818.GA55076@xxxxxxxxxxxxxxx> <20060110221055.053596ab@xxxxxxxxxxxxxxxxxxxxxxxx> <20060111075655.GA51292@xxxxxxxxxxxxxxx> <20060111072659.7c1772ad@xxxxxxxxxxxxxxxxxxxxxxxx> <20060111080237.66040a61@xxxxxxxxxxxxxxxxxxxxxxxx>

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

References:
- Index isn't used during a join.
  - From: Robert Creager
- Re: Index isn't used during a join.
  - From: Michael Fuhr
- Re: Index isn't used during a join.
  - From: Robert Creager
- Re: Index isn't used during a join.
  - From: Michael Fuhr
- Re: Index isn't used during a join.
  - From: Robert Creager
- Re: Index isn't used during a join.
  - From: Robert Creager

Prev by Date: Re: Postgres8.0 planner chooses WRONG plan
Next by Date: Re: Improving Inner Join Performance
Previous by thread: Re: Index isn't used during a join.
Next by thread: Re: Index isn't used during a join.
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux