Horton

Re: Index Scans become Seq Scans after VACUUM ANALYSE

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Loftis <mloftis@wgops.com>
Cc: Louis-David Mitterrand <vindex@apartia.org>, pgsql-hackers@postgresql.org
Date: 2002-04-17T03:52:53Z
Lists: pgsql-hackers 
Michael Loftis <mloftis@wgops.com> writes:
> Reading all of this discussion lately about how the planner seems to 
> prefer seqscan's in alot of places where indexes would be better starts 
> making me wonder if some of the assumptions or cals made to figure costs 
> are wrong...

Could well be.  The sources are open, feel free to take a look ...
src/backend/optimizer/path/costsize.c is the epicenter ...

			regards, tom lane