Re: REINDEX takes half a day (and still not complete!)

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