Re: Required locks for ANALYZE

2023-11-08 Thread Bruce Momjian
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 s

RE: Required locks for ANALYZE

2019-09-30 Thread Aramaki Zyake
ail.com Cc: pgsql-docs@lists.postgresql.org Subject: Re: Required locks for ANALYZE PG Doc comments form writes: > Therefore, in my opinion, the below paragraph should be amended as below. > * Before > - > ANALYZE requires only a read lock on the target table, so it can run in > para

Re: Required locks for ANALYZE

2019-08-20 Thread Tom Lane
PG Doc comments form writes: > Therefore, in my opinion, the below paragraph should be amended as below. > * Before > - > ANALYZE requires only a read lock on the target table, so it can run in > parallel with other activity on the table. > - > * After > - > ANALYZE requires only a S

Required locks for ANALYZE

2019-08-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/sql-select.html Description: The below document says that the ANALYZE statement requires a read lock. https://www.postgresql.org/docs/current/sql-analyze.html - ANALYZE requires only