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
