<david(at)stanaway(dot)net> writes:
> radius=# EXPLAIN SELECT * from alldata where loggedat > '2003-05-07';
> NOTICE: QUERY PLAN:
> Seq Scan on alldata (cost=0.00..286136.26 rows=1428487 width=780)
^^^^^^^^^^^^
The planner seems to think that this query will return rather a lot of
rows ... which would imply that a seqscan isn't necessarily a bad idea.
Is that rows estimate accurate? (If not, have you ANALYZEd this table
lately?)
regards, tom lane