Re: SourceForge & Postgres

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