Re: Fwd: Adding more detail to pg_upgrade documentation

2022-06-03 Thread Jack DeVries
Hi Nikhil, >From the pgupgrade docs: > 9. Prepare for standby server upgrades > > If you are upgrading standby servers using methods outlined in section > Step 11, verify that the old standby servers are caught up by running > pg_controldata against the old primary and standby clusters. Verify >

Re: Proposal to improve uniq function documentation in intarray extension

2022-06-03 Thread Tom Lane
Daniel Gustafsson writes: >> On 3 Jun 2022, at 17:34, Tom Lane wrote: >> .. there's no longer any reason we have >> to limit ourselves to one example. I propose this: > +1 Done like that, then. regards, tom lane

Re: Proposal to improve uniq function documentation in intarray extension

2022-06-03 Thread Daniel Gustafsson
> On 3 Jun 2022, at 17:34, Tom Lane wrote: > .. there's no longer any reason we have > to limit ourselves to one example. I propose this: > > diff --git a/doc/src/sgml/intarray.sgml b/doc/src/sgml/intarray.sgml > index f930c08eeb..18c6f8c3ba 100644 > --- a/doc/src/sgml/intarray.sgml > +++ b/doc

Re: Proposal to improve uniq function documentation in intarray extension

2022-06-03 Thread Tom Lane
PG Doc comments form writes: > The **uniq** function in the **intarray** extension removes **adjacent** > duplicates from an integer array. The documentation[0] about this behavior > is correct, but the example is a bit misleading, because it sorts the array > before applying uniq. The sort can be

Proposal to improve uniq function documentation in intarray extension

2022-06-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/intarray.html Description: The **uniq** function in the **intarray** extension removes **adjacent** duplicates from an integer array. The documentation[0] about this behavior is correct, b

Re: pg_stat_database view column xact_commit description should be more descriptive?

2022-06-03 Thread jian he
Sorry. It refers to all the transactions. On Fri, Jun 3, 2022 at 12:30 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > > > On Thursday, June 2, 2022, jian he wrote: > >> >> >> https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-DATABASE-VIEW >> >>> xact_c

Re: pg_stat_database view column xact_commit description should be more descriptive?

2022-06-03 Thread David G. Johnston
On Thursday, June 2, 2022, jian he wrote: > > https://www.postgresql.org/docs/current/monitoring-stats. > html#MONITORING-PG-STAT-DATABASE-VIEW > >> xact_commit bigint >> >> Number of transactions in this database that have been committed >> > In https://www.postgresql.org/docs/current/sql-begin.