Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 11 Jan 2006 02:00:08 -0700
- Message-id: <20060111090008.GA51672@winnie.fuhr.org> <text/plain>
On Wed, Jan 11, 2006 at 12:56:55AM -0700, Michael Fuhr wrote:
> WHERE ...
> AND doy >= EXTRACT(doy FROM now() - '24 hour'::interval)
> AND doy <= EXTRACT(doy FROM now())
To work on 1 Jan this should be more like
WHERE ...
AND (doy = EXTRACT(doy FROM now() - '24 hour'::interval) OR
doy = EXTRACT(doy FROM now()))
In any case the point is to add conditions to the WHERE clause that
will use an index on the table for which you're currently getting
a sequential scan.
--
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
- Index isn't used during a join.
- Prev by Date: Re: NOT LIKE much faster than LIKE?
- Next by Date: Re: NOT LIKE much faster than LIKE?
- Previous by thread: Re: Index isn't used during a join.
- Next by thread: Re: Index isn't used during a join.
- Indexes: