mlw <markw(at)mohawksoft(dot)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