diff options
Diffstat (limited to 'doc/src/sgml/ref')
-rw-r--r-- | doc/src/sgml/ref/drop_index.sgml | 7 | ||||
-rw-r--r-- | doc/src/sgml/ref/reindex.sgml | 17 | ||||
-rw-r--r-- | doc/src/sgml/ref/vacuum.sgml | 4 |
3 files changed, 15 insertions, 13 deletions
diff --git a/doc/src/sgml/ref/drop_index.sgml b/doc/src/sgml/ref/drop_index.sgml index b6d2c2014f2..aabc85e2300 100644 --- a/doc/src/sgml/ref/drop_index.sgml +++ b/doc/src/sgml/ref/drop_index.sgml @@ -45,9 +45,10 @@ DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] <replaceable class="parameter">name</r <para> Drop the index without locking out concurrent selects, inserts, updates, and deletes on the index's table. A normal <command>DROP INDEX</command> - acquires an exclusive lock on the table, blocking other accesses until the - index drop can be completed. With this option, the command instead - waits until conflicting transactions have completed. + acquires an <literal>ACCESS EXCLUSIVE</literal> lock on the table, + blocking other accesses until the index drop can be completed. With + this option, the command instead waits until conflicting transactions + have completed. </para> <para> There are several caveats to be aware of when using this option. diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index ff4dba8c363..5875ecb93f7 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -282,14 +282,15 @@ REINDEX [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] { IN <command>REINDEX</command> is similar to a drop and recreate of the index in that the index contents are rebuilt from scratch. However, the locking considerations are rather different. <command>REINDEX</command> locks out writes - 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, <command>DROP INDEX</command> momentarily takes - an exclusive lock on the parent table, blocking both writes and reads. The - subsequent <command>CREATE INDEX</command> 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. + but not reads of the index's parent table. It also takes an + <literal>ACCESS EXCLUSIVE</literal> lock on the specific index being processed, + which will block reads that attempt to use that index. In contrast, + <command>DROP INDEX</command> momentarily takes an + <literal>ACCESS EXCLUSIVE</literal> lock on the parent table, blocking both + writes and reads. The subsequent <command>CREATE INDEX</command> 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. </para> <para> diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index bb1c0f8fb6f..6a0028a5142 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -83,8 +83,8 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ ANALYZE ] [ <replaceable class="paramet specify parallel workers as zero. <command>VACUUM FULL</command> rewrites the entire contents of the table into a new disk file with no extra space, allowing unused space to be returned to the operating system. This form is - much slower and requires an exclusive lock on each table while it is being - processed. + much slower and requires an <literal>ACCESS EXCLUSIVE</literal> lock on + each table while it is being processed. </para> <para> |