From: Bruce Momjian <bruce@momjian.us>
To: Aramaki Zyake <zyake.mk4@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: Required locks for ANALYZE
Date: Wed, 8 Nov 2023 16:06:42 -0500
Message-ID: <ZUv4Ytt-vVMSLrb8@momjian.us> (raw)
In-Reply-To: <5d91b2f1.1c69fb81.bf75c.2036@mx.google.com>
References: <156628723253.1296.7377373462603881976@wrigleys.postgresql.org>
<6129.1566310344@sss.pgh.pa.us>
<5d91b2f1.1c69fb81.bf75c.2036@mx.google.com>
On Mon, Sep 30, 2019 at 04:46:56PM +0900, Aramaki Zyake wrote:
> Hi,
>
> I’m terribly sorry for the delay of response.
>
>
>
> >This does not really seem like an improvement. The second formulation is
>
> >pedantically correct, but also unintelligible.
>
> >
>
> > Maybe we could make it say "run in parallel with non-DDL activity" ?
>
>
>
> I completely agree with you, therefore, I amended it as follows.
>
> ----
>
> ANALYZE requires only a read lock on the target table, so it can run in
>
> parallel with non-DDL activity on the table.
I know this report is four years old, but attached patch applied to
master.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
Attachments:
[text/x-diff] analyze.diff (517B, ../ZUv4Ytt-vVMSLrb8@momjian.us/2-analyze.diff)
download | inline diff:diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgmlindex 4c79a01eb6..6ed8e7241b 100644--- a/doc/src/sgml/ref/analyze.sgml+++ b/doc/src/sgml/ref/analyze.sgml@@ -208,7 +208,7 @@ ANALYZE [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] [ <r
<para>
<command>ANALYZE</command>
requires only a read lock on the target table, so it can run in
- parallel with other activity on the table.+ parallel with other non-DDL activity on the table.
</para>
<para>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, zyake.mk4@gmail.com, tgl@sss.pgh.pa.us, pgsql-docs@lists.postgresql.org
Subject: Re: Required locks for ANALYZE
In-Reply-To: <ZUv4Ytt-vVMSLrb8@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox