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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Phoenix Kiula <phoenix.kiula@xxxxxxxxx>
Subject: Re: REINDEX takes half a day (and still not complete!)
From: Jesper Krogh <jesper@xxxxxxxx>
Date: Sun, 17 Apr 2011 17:45:24 +0200
Cc: Merlin Moncure <mmoncure@xxxxxxxxx>, "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <BANLkTinq7KSstviqjGfnaKh7YOfan7sjig@xxxxxxxxxxxxxx>
References: <AANLkTim1aO2hG+D4h_VFXas8GTL6TQMLj7aDc7tJ0vok@xxxxxxxxxxxxxx> <AANLkTinjsS7Aj0ZoMVq3ZDhKepBsZ_HOpBqEjRrabk_J@xxxxxxxxxxxxxx> <BANLkTinq7KSstviqjGfnaKh7YOfan7sjig@xxxxxxxxxxxxxx>

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

References:
- REINDEX takes half a day (and still not complete!)
  - From: Phoenix Kiula
- Re: REINDEX takes half a day (and still not complete!)
  - From: Merlin Moncure
- Re: REINDEX takes half a day (and still not complete!)
  - From: Phoenix Kiula

Prev by Date: Re: REINDEX takes half a day (and still not complete!)
Next by Date: Re: REINDEX takes half a day (and still not complete!)
Previous by thread: Re: REINDEX takes half a day (and still not complete!)
Next by thread: Re: REINDEX takes half a day (and still not complete!)
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux