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
