On 04/23/2011 03:44 PM, Robert Haas wrote:
> On Apr 17, 2011, at 11:30 AM, Phoenix Kiula<phoenix.kiula@gmail.com> 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
probablywant 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.
Sometimesthat'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@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us