Scott Marlowe <[EMAIL PROTECTED]> 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.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to