Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitbae0b5c

Browse files
committed
doc: small fixes for REINDEX reference page
From: Josh Kupershmidt <schmiddy@gmail.com>
1 parent77b5586 commitbae0b5c

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

‎doc/src/sgml/ref/reindex.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff 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</>, thatit is contains many
49+
An index has become <quote>bloated</>, thatis 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+
anexclusive 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

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp