Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance Problem Index Ignored, but why - Mailing list pgsql-admin

From Tom Lane
Subject Re: Performance Problem Index Ignored, but why
Date
Msg-id 21113.1022041595@sss.pgh.pa.us
Whole thread Raw
In response to Performance Problem Index Ignored, but why  ("Thomas A. Lowery" <tlowery@stlowery.net>)
List pgsql-admin
Tree view 
"Thomas A. Lowery" <tlowery@stlowery.net> writes:
> Can I force the use of an index?

Try "set enable_seqscan = off".  But on the basis of what you've shown,
it's not obvious that an indexscan will be faster.  Is the planner's
estimate that 139654 rows will match f_state = 'PA' in the right
ballpark?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Thomas A. Lowery"
Date:
Subject: Performance Problem Index Ignored, but why
Next
From: "James Kelty"
Date:
Subject: Rserv and Boolean...