From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-performance@postgresql.org
Subject: Re: REINDEX takes half a day (and still not complete!)
Date: Sat, 30 Apr 2011 04:07:13 -0400
Message-ID: <4DBBC331.7080200@2ndQuadrant.com> (raw)
In-Reply-To: <34CE0668-2A83-4BE4-B191-86871C2F8334@gmail.com>
References: <AANLkTim1aO2hG+D4h_VFXas8GTL6TQMLj7aDc7tJ0vok@mail.gmail.com>
<AANLkTinjsS7Aj0ZoMVq3ZDhKepBsZ_HOpBqEjRrabk_J@mail.gmail.com>
<BANLkTinq7KSstviqjGfnaKh7YOfan7sjig@mail.gmail.com>
<34CE0668-2A83-4BE4-B191-86871C2F8334@gmail.com>
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 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@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndQuadrant.com
Subject: Re: REINDEX takes half a day (and still not complete!)
In-Reply-To: <4DBBC331.7080200@2ndQuadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox