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/
