Re: [GENERAL] I feel the need for speed. What am I doing wrong?

johnnnnnn <john(at)phaedrusdeinus(dot)org> writes:
> On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
>> -> Seq Scan on CNX_DS_53_SIS_STU_OPT_FEE_TB a
>> (cost=100000000.00..100112549.62 rows=6139062 width=24)

> Those big round numbers suggest that you haven't run vacuum analyze on
> all of your tables.

No; the 100000000.00 is a tipoff that he's set enable_seqscan off, but
the system is using a seqscan anyway because it cannot find any other
plan.

"SET enable_seqscan = off" does not prevent the planner from generating
seqscan plans, it just adds 100000000.00 to the cost estimate. That
will generally cause the planner to pick another plan --- if it can find
one. In this case it evidently cannot find any indexscan alternative.

regards, tom lane