On 1/16/07, Jeremy Haile <[EMAIL PROTECTED]> 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/
