Search Postgresql Archives

Excessive vacuum times

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Some time ago I reported a problem where right after an index rebuild vacuum
might take a couple of hours, but gets slower and slower at a seeming
increasing rate as time goes on.  What takes a couple of ours after a full
index rebuild now takes 12 hours or more.

The problem was determined to be due to the fact that indexes are vacuumed
in index order, not in disk storage order.  I don't see anything about this
in the "What's new" for 8.1.  Has anything been done to resolve this?

Scheduled index rebuilds are not feasible.  I really don't even want to take
a chance on starting one.  The database is just a hair under one billion
rows, and could take the entire weekend or more to rebuild.

Wes




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux