Bruce Momjian wrote:
> This is great news. As far as the optimizer, any chance of testing 7.1
> to see if it is improved. I believe it has been over 7.0.3.
I just did a test of my database that exhibits this behavior, using 7.1
from CVS.
When postmaster is started with "-o -fs" I get this:
cdinfo=# explain select * from ztitles where artistid = 0 ;
NOTICE: QUERY PLAN:
Index Scan using ztitles_artistid_ndx on ztitles (cost=0.00..5915.01
rows=3163 width=296)
EXPLAIN
When postmaster is started without "-o -fs" I get this:
cdinfo=# explain select * from ztitles where artistid = 0 ;
NOTICE: QUERY PLAN:
Seq Scan on ztitles (cost=0.00..4740.75 rows=3163 width=296)
EXPLAIN
--
http://www.mohawksoft.com