Re: Best practice when reindexing in production

On Wednesday, May 29, 2013, Niels Kristian Schjødt wrote:

> Hi,
>
> I have a database with quite some data (millions of rows), that is heavily
> updated all the time. Once a day I would like to reindex my database (and
> maybe re cluster it - don't know if that's worth it yet?). I need the
> database to be usable while doing this (both read and write). I see that
> there is no way to REINDEX CONCURRENTLY - So what approach would you
> suggest that I take on this?
>

I think the "best practice" is...not to do it in the first place.

There are some cases where it probably makes sense to reindex on a regular
schedule. But unless you can specifically identify why you have one of
those cases, then you probably don't have one.

Cheers,

Jeff