Re: Indices are not used by the optimizer

Are you really expecting 19 million rows to be returned -- are you
really going to use them all?

How about explain analyze output?

Have you tried using a cursor to allow for parallel processing? (pull
1000 rows, do work, pull next 1000 rows, do work, etc.)

> wetter=# explain select * from wetter where epoche > '2001-01-01';
>                                 QUERY PLAN
> -------------------------------------------------------------------------
>   Seq Scan on wetter  (cost=0.00..614795.55 rows=19054156 width=16)
>     Filter: (epoche > '2001-01-01 00:00:00+00'::timestamp with time zone)
> (2 rows)

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc