Horton

Re: PG 14 release notes, first draft

Amit Kapila <amit.kapila16@gmail.com>

View thread View on postgr.es
From: Amit Kapila <amit.kapila16@gmail.com>
To: "Jonathan S. Katz" <jkatz@postgresql.org>
Cc: Justin Pryzby <pryzby@telsasoft.com>, Bruce Momjian <bruce@momjian.us>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2021-05-12T03:45:55Z
Lists: pgsql-hackers 
On Tue, May 11, 2021 at 6:43 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:
>
> First Bruce, thank you for compiling the release notes draft. Comments
> inline:
>
> On 5/10/21 11:56 PM, Amit Kapila wrote:
> > On Mon, May 10, 2021 at 7:30 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
> >>
> >> Can these be merged:
> >>  Allow logical replication to stream long transactions to standbys (Dilip Kumar, Tomas Vondra, Amit Kapila, Nikhil Sontakke)
> >>  Improve the logical replication API to allow streaming large in-progress transactions (Tomas Vondra, Dilip Kumar, Amit Kapila)
> >>
> >
> > I think we should merge the below two:
> > Add support for streaming to built-in logical replication (Vondra,
> > Dilip Kumar, Amit Kapila, Ajin Cherian, Nikhil Sontakke, Stas Kelvich)
> >
> > Allow logical replication to stream long transactions to standbys
> > (Dilip Kumar, Tomas Vondra, Amit Kapila, Nikhil Sontakke)
> >
> > and say something like:
> > Allow logical replication to stream long in-progress transactions to standbys
> > Previously transactions that exceeded logical_decoding_work_mem were
> > written to disk until the transaction completed.
>
> I was going to post a question about the above bullet point(s), so this
> clarification helps -- thanks!
>
> Two comments on the above:
>
> 1. I do believe ther eis a missing "Tomas" in the first release note.
> 2. Would you want to s/standbys/subscribers/ given an instance can be in
> read/write mode but still receive logical changes?
>

Right, that makes sense to me.

-- 
With Regards,
Amit Kapila.

Commits

  1. doc: add mention of +4GB windows file handling in PG14 relnotes

  2. doc: PG 14 relnotes fixes

  3. doc: PG 14 relnote updates

  4. doc: PG 14 relnotes, adjust pg_{read|write}_all_data entry

  5. Update PG 14 relnotes for vacuum_cost_page_miss

  6. doc: update PG 14 release notes with recent feedback

  7. Update replication statistics after every stream/spill.

  8. Add information of total data processed to replication slot stats.

  9. Use NameData datatype for slotname in stats.

  10. Add back vacuum_cleanup_index_scale_factor parameter.

  11. Don't consider newly inserted tuples in nbtree VACUUM.

  12. pgbench: Improve time logic.

  13. Track total amounts of times spent writing and syncing WAL data to disk.

  14. Allow decoding at prepare time in ReorderBuffer.

  15. Extend the output plugin API to allow decoding of prepared xacts.

  16. Fix nbtree cleanup-only VACUUM stats inaccuracies.

  17. Execute invalidation messages for each XLOG_XACT_INVALIDATIONS message

  18. Fix our Windows stat() emulation to handle file sizes > 4GB.

  19. Trigger autovacuum based on number of INSERTs

  20. Speed up planning when partitions can be pruned at plan time.

  21. Remove support for password_encryption='off' / 'plain'.

  22. Increase work_mem and maintenance_work_mem defaults by 4x