Horton

Re: First draft of the PG 15 release notes

Amit Kapila <amit.kapila16@gmail.com>

View thread View on postgr.es
From: Amit Kapila <amit.kapila16@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: "Jonathan S. Katz" <jkatz@postgresql.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2022-05-12T11:10:49Z
Lists: pgsql-hackers 
On Thu, May 12, 2022 at 2:25 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Wed, May 11, 2022 at 2:02 AM Bruce Momjian <bruce@momjian.us> wrote:
> >
> > On Tue, May 10, 2022 at 04:17:59PM -0400, Jonathan Katz wrote:
> > > On 5/10/22 11:44 AM, Bruce Momjian wrote:
> > > > I have completed the first draft of the PG 15 release notes and you can
> > > > see the results here:
> > > >
> > > >          https://momjian.us/pgsql_docs/release-15.html
> > >
> > > Thanks for pulling this together.
> > >
> > > + Allow logical replication to transfer sequence changes
> > >
> > > I believe this was reverted in 2c7ea57e5, unless some other parts of this
> > > work made it in.
> >
> > Yes, sorry, I missed that.  Oddly, the unlogged sequence patch was
> > retained, even though there is no value for it on the primary.  I
> > removed the sentence that mentioned that benefit from the release notes
> > since it doesn't apply to PG 15 anymore.
> >
>
> + Create unlogged sequences and allow them to be skipped in logical replication
>
> Is it right to say the second part of the sentence: "allow them to be
> skipped in logical replication" when we are not replicating them in
> the first place?
>

One more point related to logical replication features:

>
Add SQL functions to monitor the directory contents of replication
slots (Bharath Rupireddy)

Specifically, the functions are pg_ls_logicalsnapdir(),
pg_ls_logicalmapdir(), and pg_ls_replslotdir(). They can be run by
members of the predefined pg_monitor role.
>

This feature is currently under the section "Streaming Replication and
Recovery". Shouldn't it be under "Logical Replication"? The function
names themselves seem to indicate that they are used for logical
replication contents. I think the replication slot-related function
would fall under both categories but overall it seems to belong to the
"Logical Replication" section.

-- 
With Regards,
Amit Kapila.

Commits

  1. Doc: last minute adjustment to the release notes

  2. Doc: more tweaking of v15 release notes.

  3. Doc: further adjust notes about pg_upgrade_output.d.

  4. Doc: add list of major features to the v15 release notes.

  5. relnotes: update item about public schema permission change

  6. relnotes: update ordered partition scan item

  7. relnotes: add Heikki to UTF8 item

  8. relnotes: improve UTF8 text item in relation to ASCII

  9. relnotes: add null logical replication item

  10. relnotes: adjust several logical replication items and FK text

  11. relnotes: mention non-exclusive backup mode was deprecated

  12. relnotes: add author to in-memory sorts item

  13. relnotes: update for non-exclusive backup mode removal

  14. relnote: improve sorting entries

  15. relnotes: adjustments from Álvaro Herrera

  16. relnotes: update foreign key partition and add sort items

  17. relnotes: more adjustments

  18. relnotes: logical replication permissions checked by subscrib.

  19. relnotes: adjustments

  20. relnotes: remove sequence replication and update 'postgres -C'

  21. relnote: extensive updates

  22. relnotes: "training" -> "trailing"

  23. Standardize references to Zstandard as <productname>

  24. pgstat: Update docs to match the shared memory stats reality.

  25. Raise a WARNING for missing publications.

  26. Skip empty transactions for logical replication.

  27. Optionally disable subscriptions on error.

  28. Allow root-owned SSL private keys in libpq, not only the backend.

  29. Use COPY FREEZE in pgbench for faster benchmark table population.