diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-11-18 18:42:03 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-11-18 18:42:03 +0000 |
| commit | 7129f26be0586b333a0a3386b3a4661c36148f48 (patch) | |
| tree | 8659b0c786b1801760f3f380ba4b2a94eff09710 | |
| parent | b13602c6d0d44500675ff1da98d0156e1ea40165 (diff) | |
Remove no-longer-accurate claim that REINDEX won't invalidate cached
plans.
| -rw-r--r-- | doc/src/sgml/ref/reindex.sgml | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index d6d1a13279e..03e2736f794 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/reindex.sgml,v 1.36 2007/01/31 23:26:04 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/reindex.sgml,v 1.37 2007/11/18 18:42:03 tgl Exp $ PostgreSQL documentation --> @@ -231,9 +231,7 @@ REINDEX { INDEX | TABLE | DATABASE | SYSTEM } <replaceable class="PARAMETER">nam subsequent <command>CREATE INDEX</> locks out writes but not reads; since the index is not there, no read will attempt to use it, meaning that there will be no blocking but reads might be forced into expensive sequential - scans. Another important point is that the drop/create approach - invalidates any cached query plans that use the index, while - <command>REINDEX</> does not. + scans. </para> <para> |