Re: Slow SELECT

psql-mail@freeuk.com writes:
> I am running a SELECT to get all tuples within a given date range. This
> query is much slwoer than i expected - am i missing something?

Well, it seems to be running at about 5 msec/row, which would be quite
respectable if each fetch required another disk seek.  I'm wondering why
you are (apparently) not managing to get more than one row per page
fetched.  What are your configuration settings --- particularly
shared_buffers?  Could we see the output of VACUUM VERBOSE for this
table?

            regards, tom lane