| From: | Greg Smith <greg(at)2ndQuadrant(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: REINDEX takes half a day (and still not complete!) |
| Date: | 2011-04-30 08:07:13 |
| Message-ID: | 4DBBC331.7080200@2ndQuadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 04/23/2011 03:44 PM, Robert Haas wrote:
> On Apr 17, 2011, at 11:30 AM, Phoenix Kiula<phoenix(dot)kiula(at)gmail(dot)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(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hsien-Wen Chu | 2011-04-30 08:51:11 | Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql? |
| Previous Message | Greg Smith | 2011-04-30 04:47:49 | Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql? |