"Thomas A. Lowery" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
