On 04/23/2011 03:44 PM, Robert Haas wrote:
On Apr 17, 2011, at 11:30 AM, Phoenix Kiula<phoenix.kiula@xxxxxxxxx> wrote:
Postgres is 8.2.9.
An upgrade would probably help you a lot, and as others have said it sounds like your hardware is failing, so you probably want to deal with that first.
I am a bit surprised, however, that no one seems to have mentioned using CLUSTER rather than VACUUM or REINDEX. Sometimes that's worth a try...
Don't know if it was for this reason or not for not mentioning it by
others, but CLUSTER isn't so great in 8.2. The whole "not MVCC-safe"
bit does not inspire confidence on a production server.
--
Greg Smith 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
