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

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: REINDEX takes half a day (and still not complete!)
Date: 2011-04-17 15:45:24
Message-ID: C43BAB96-EA42-46DA-A456-B00AB8E65BA5@krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
>
> How do DB folks do this with small maintenance windows? This is for a
> very high traffic website so it's beginning to get embarrassing.

Normally there is no need to issue reindex. What's your reason for the need?

Jesper

>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2011-04-17 16:09:45 Re: REINDEX takes half a day (and still not complete!)
Previous Message Scott Marlowe 2011-04-17 15:44:04 Re: REINDEX takes half a day (and still not complete!)