Re: Change JOIN tutorial to focus more on explicit joins

2020-05-20 Thread Thomas Munro
On Thu, May 21, 2020 at 1:37 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/tutorial-join.html > Description: > > The tutorial about joins makes the following statement about the explicit > JOIN oper

Re: descriptions of pg_stat_user_functions and pg_stat_slru

2020-05-20 Thread Tom Lane
Fujii Masao writes: > On 2020/05/20 22:32, Tom Lane wrote: >> OK by me --- that, too, would be more like the existing catalogs >> chapter. > Yeah, so I'd like to propose the attached patch. Hmmm ... I'm not exactly convinced about sticking xreflabels onto the s as you've done here. Presumably t

Re: ATTACH/DETACH partitions and locking

2020-05-20 Thread Alvaro Herrera
On 2019-Jun-14, Pavel Luzanov wrote: > Does it make sense to change this way? > "Some operations require a stronger lock when using declarative partitioning > than when using table inheritance. For example, removing a > partition from a partitioned table requires taking an ACCESS EXCLUSIVE > lock

Re: descriptions of pg_stat_user_functions and pg_stat_slru

2020-05-20 Thread Fujii Masao
On 2020/05/20 22:32, Tom Lane wrote: Fujii Masao writes: Also I don't like that all the stats views are packed in one section currently. Which makes the docs difficult to read, I'm afraid. Thought? If we change the layout entirely, at the same time, what about separating each view into differ

Change JOIN tutorial to focus more on explicit joins

2020-05-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-join.html Description: The tutorial about joins makes the following statement about the explicit JOIN operator: > This syntax is not as commonly used as the one above I think in

Re: descriptions of pg_stat_user_functions and pg_stat_slru

2020-05-20 Thread Tom Lane
Fujii Masao writes: > Also I don't like that all the stats views are packed in one section > currently. Which makes the docs difficult to read, I'm afraid. Thought? > If we change the layout entirely, at the same time, what about separating > each view into different section by adding ? OK by me

Re: Add A Glossary

2020-05-20 Thread Laurenz Albe
On Wed, 2020-05-20 at 13:17 +0200, Jürgen Purtz wrote: > > FWIW, I feel somewhat like Alvaro on that point; I use those terms > > synonymously, > > perhaps distinguishing between a "started cluster" and a "stopped cluster". > > After all, "cluster" refers to "a cluster of databases", which are the

Re: Add A Glossary

2020-05-20 Thread Jürgen Purtz
On 19.05.20 08:17, Laurenz Albe wrote: On Mon, 2020-05-18 at 18:08 +0200, Jürgen Purtz wrote: cluster/instance: PG (mainly) consists of a group of processes that commonly act on shared buffers. The processes are very closely related to each other and with the buffers. They exist altogether or no

Re: Missing comma?

2020-05-20 Thread Marina Polyakova
On 2020-05-20 08:26, Michael Paquier wrote: On Tue, May 19, 2020 at 11:14:56AM +0300, Marina Polyakova wrote: Here is a patch with a fixed commit message (primary index => primary key). Thanks, applied. Thank you! -- Marina Polyakova Postgres Professional: http://www.postgrespro.com The Rus