On 1/16/07, Jeremy Haile <jhaile(at)fastmail(dot)fm> wrote:
>
> Even if unrelated, do you think disk fragmentation would have negative
> effects? Is it worth trying to defragment the drive on a regular basis
> in Windows?
>
Out of curiosity, is this table heavily updated or deleted from? Perhaps
there is an unfavorable "correlation" between the btree and data? Can you
dump the results of
select attname, null_frac, avg_width, n_distinct, correlation from pg_stats
where tablename = 'transaction_facts'
--
Chad
http://www.postgresqlforums.com/