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