Postgres Pro
Downloads
Home   >   mailing lists

Re: Not using indexes in WHERE clauses - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Not using indexes in WHERE clauses
Date
Msg-id 8556.979919246@sss.pgh.pa.us
Whole thread Raw
In response to Not using indexes in WHERE clauses  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
Using a seqscan to retrieve half of the entries in a table is not a bug,
it is correct behavior.

Your test case might make you think otherwise, but that's because your
test data is artificially well-ordered.  Try the two methods with the
same data loaded in a random order ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Not using indexes in WHERE clauses
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: installation fails