diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-09-29 23:40:26 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-09-29 23:40:26 +0000 |
| commit | e33f205a945e7497b9aecffffb7e3b0a199f8a29 (patch) | |
| tree | cf5d530e56ed7d44b379058f479949a98050291e /doc/src | |
| parent | 6b4caf53e632db88a7bae21a0494c50b54120e38 (diff) | |
| download | postgresql-e33f205a945e7497b9aecffffb7e3b0a199f8a29.tar.gz postgresql-e33f205a945e7497b9aecffffb7e3b0a199f8a29.zip | |
Adjust btree index build procedure so that the btree metapage looks
invalid (has the wrong magic number) until the build is entirely
complete. This turns out to cost no additional writes in the normal
case, since we were rewriting the metapage at the end of the process
anyway. In normal scenarios there's no real gain in security, because
a failed index build would roll back the transaction leaving an unused
index file, but for rebuilding shared system indexes this seems to add
some useful protection.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/reindex.sgml | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index d945112de79..43f0368d64a 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/reindex.sgml,v 1.21 2003/09/24 18:54:01 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/reindex.sgml,v 1.22 2003/09/29 23:40:26 tgl Exp $ PostgreSQL documentation --> @@ -180,9 +180,10 @@ REINDEX { DATABASE | TABLE | INDEX } <replaceable class="PARAMETER">name</replac is crash-safe and transaction-safe. <command>REINDEX</> is not crash-safe for shared indexes, which is why this case is disallowed during normal operation. If a failure occurs while reindexing one - of these catalogs in standalone mode, it is important that the failure - be rectified and the <command>REINDEX</> operation redone - before attempting to restart the regular server. + of these catalogs in standalone mode, it will not be possible to + restart the regular server until the problem is rectified. (The + typical symptom of a partially rebuilt shared index is <quote>index is not + a btree</> errors.) </para> <para> |