Re: SourceForge & Postgres

mlw <markw@mohawksoft.com> writes:
> 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)

> 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)

How many tuples are in the table?  How many are actually returned
by this query?  Also, what do you get from

select attname,attdisbursion,s.*
from pg_statistic s, pg_attribute a, pg_class c
where starelid = c.oid and attrelid = c.oid and staattnum = attnum
and relname = 'ztitles';
        regards, tom lane