Date: Wed, 8 Nov 2023 16:06:42 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Aramaki Zyake <zyake.mk4@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: Re: Required locks for ANALYZE
Message-ID: <ZUv4Ytt-vVMSLrb8@momjian.us>
References: <156628723253.1296.7377373462603881976@wrigleys.postgresql.org>
 <6129.1566310344@sss.pgh.pa.us>
 <5d91b2f1.1c69fb81.bf75c.2036@mx.google.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="BuovsKgNDjBW/RYv"
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <5d91b2f1.1c69fb81.bf75c.2036@mx.google.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZUv4Ytt-vVMSLrb8%40momjian.us>
Precedence: bulk


--BuovsKgNDjBW/RYv
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit

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.

--BuovsKgNDjBW/RYv
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="analyze.diff"

diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml
index 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>

--BuovsKgNDjBW/RYv--