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 07:56:55
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-performance

On Tue, Jan 10, 2006 at 10:10:55PM -0700, Robert Creager wrote:
> The query is now correct, but still is slow because of lack of
> index usage. I don't know how to structure the query correctly to
> use the index.

Have you tried adding restrictions on doy in the WHERE clause?
Something like this, I think:

AND doy >= EXTRACT(doy FROM now() - '24 hour'::interval)
AND doy <= EXTRACT(doy FROM now())

Something else occurred to me: do you (or will you) have more than
one year of data? If so then matching on doy could be problematic
unless you also check for the year, or unless you want to match
more than one year.

Michael Fuhr

In response to


Browse pgsql-performance by date

  From Date Subject
Next Message Andrea Arcangeli 2006-01-11 07:59:56 Re: NOT LIKE much faster than LIKE?
Previous Message Ron 2006-01-11 06:03:48 Re: help tuning queries on large database