File tree Expand file tree Collapse file tree 1 file changed +2
-2
lines changed
Expand file tree Collapse file tree 1 file changed +2
-2
lines changed Original file line number Diff line number Diff line change @@ -46,7 +46,7 @@ REINDEX { INDEX | TABLE | DATABASE | SYSTEM } <replaceable class="PARAMETER">nam
4646
4747 <listitem>
4848 <para>
49- An index has become <quote>bloated</>, that it is contains many
49+ An index has become <quote>bloated</>, that is it contains many
5050 empty or nearly-empty pages. This can occur with B-tree indexes in
5151 <productname>PostgreSQL</productname> under certain uncommon access
5252 patterns. <command>REINDEX</command> provides a way to reduce
@@ -228,7 +228,7 @@ REINDEX { INDEX | TABLE | DATABASE | SYSTEM } <replaceable class="PARAMETER">nam
228228 but not reads of the index's parent table. It also takes an exclusive lock
229229 on the specific index being processed, which will block reads that attempt
230230 to use that index. In contrast, <command>DROP INDEX</> momentarily takes
231- exclusive lock on the parent table, blocking both writes and reads. The
231+ an exclusive lock on the parent table, blocking both writes and reads. The
232232 subsequent <command>CREATE INDEX</> locks out writes but not reads; since
233233 the index is not there, no read will attempt to use it, meaning that there
234234 will be no blocking but reads might be forced into expensive sequential
You can’t perform that action at this time.
0 commit comments