Horton

Re: PG 13 release notes, first draft

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: Justin Pryzby <pryzby@telsasoft.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2020-05-12T02:49:54Z
Lists: pgsql-hackers 
On Tue, May 12, 2020 at 6:36 AM Bruce Momjian <bruce@momjian.us> wrote:
>
> On Mon, May 11, 2020 at 07:41:55PM -0500, Justin Pryzby wrote:
> > On Mon, May 11, 2020 at 10:52:41AM +0530, Amit Kapila wrote:
> > > One more observation:
> > >
> > > Allow inserts to trigger autovacuum activity (Laurenz Albe, Darafei
> > > Praliaskouski)
> > > This new behavior allows pages to be set as all-visible, which then
> > > allows index-only scans, ...
> >
> > > The above sentence sounds to mean that this feature allows index-only
> > > scans in more number of cases after this feature.  Is that what you
> > > intend to say? If so, is that correct?  Because I think this will
> > > allow index-only scans to skip "Heap Fetches" in more cases.
> >
> > I think what you mean is that the autovacuum feature, in addition to
> > encouraging the *planner* to choose an indexonly scan, will *also* allow (at
> > execution time) fewer heap fetches for a plan which would have
> > already/previously used IOS.  Right ?  So maybe it should say "allows OR
> > IMPROVES index-only scans" or "allows plans which use IOS to run more
> > efficiently".
>
> Yes, I see your point now.  New text is:
>
>         This new behavior reduces the work necessary when the table
>         needs to be frozen and allows pages to be set as all-visible.
>         All-visible pages allow index-only scans to access fewer heap rows.
>

The next text LGTM.  Thanks.

--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

Commits

  1. Doc: improve release notes' info about FROM UNPACKAGED feature removal.

  2. Doc: fix misstatement in v13 release notes.

  3. Doc: some more v13 release note tweaking.

  4. Doc: update v13 release notes through today, do a copy-editing pass.

  5. Doc: fill in "major enhancements" list in v13 release notes.

  6. doc: PG 13 relnotes: fix typos

  7. doc: PG 13 relnotes, update TOAST item to mention decompression

  8. pgbench: document that the default data loading is client-side

  9. psql \d: Display table where trigger is defined, if inherited

  10. Skip WAL for new relfilenodes, under wal_level=minimal.

  11. Introduce vacuum errcontext to display additional information.

  12. Fix lquery's behavior for consecutive '*' items.

  13. Improve the internal implementation of ereport().

  14. Add object names to partition integrity violations.

  15. Allow page lock to conflict among parallel group members.

  16. Allow relation extension lock to conflict among parallel group members.

  17. Introduce "anycompatible" family of polymorphic types.

  18. Improve checking of child pages in contrib/amcheck.

  19. doc: Add information about new SQL part SQL/MDA

  20. Added relation name in error messages for constraint checks.

  21. Avoid full scan of GIN indexes when possible

  22. Use carriage returns for data insertion logs in pgbench on terminal

  23. Use memcpy instead of a byte loop in pglz_decompress

  24. Add backtrace support for error reporting

  25. Improve pruning of a default partition

  26. Improve psql's \d output for partitioned indexes.

  27. initdb: Change authentication defaults