On Thu, 2006-08-03 at 18:03, Tom Lane wrote: > Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> writes: > > Reindex was originally > > designed to fix broken indexes, and, at least in earlier encarnations, > > should something stop it in the middle of reindexing I believe it is > > possible to be left with no index. > > That was once true but these days reindex is perfectly crash-safe. The > only case where it's not is where you want to reindex a shared catalog's > index (eg one of pg_database's), and we don't let you do that in > multiuser mode anyway. Oh cool! nice to know that's since been fixed.