From 8b300ce87dd56a83bdd97197d93a2edefaeba66a Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Mon, 14 Jul 2014 20:37:00 -0400 Subject: [PATCH] doc: small fixes for REINDEX reference page From: Josh Kupershmidt --- doc/src/sgml/ref/reindex.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index e54253106a7..ca4147b40a8 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -46,7 +46,7 @@ REINDEX { INDEX | TABLE | DATABASE | SYSTEM } nam - An index has become bloated, that it is contains many + An index has become bloated, that is it contains many empty or nearly-empty pages. This can occur with B-tree indexes in PostgreSQL under certain uncommon access patterns. REINDEX provides a way to reduce @@ -204,7 +204,7 @@ REINDEX { INDEX | TABLE | DATABASE | SYSTEM } nam but not reads of the index's parent table. It also takes an exclusive lock on the specific index being processed, which will block reads that attempt to use that index. In contrast, DROP INDEX momentarily takes - exclusive lock on the parent table, blocking both writes and reads. The + an exclusive lock on the parent table, blocking both writes and reads. The subsequent 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 -- 2.39.5