Horton

Re: PG 14 release notes, first draft

Bruce Momjian <bruce@momjian.us>

View thread View on postgr.es
From: Bruce Momjian <bruce@momjian.us>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Justin Pryzby <pryzby@telsasoft.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2021-05-11T20:41:19Z
Lists: pgsql-hackers 
On Mon, May 10, 2021 at 08:08:01AM -0700, Peter Geoghegan wrote:
> On Mon, May 10, 2021 at 7:00 AM Justin Pryzby <pryzby@telsasoft.com> wrote:
> > | Allow VACUUM VERBOSE to report page deletion counts for each scan of an index (Peter Geoghegan)
> >
> > I think "Allow" is wrong - should just say that VACUUM VERBOSE reports..
> 
> It's also not accurate, since the count of deleted pages was always
> shown by VACUUM VERBOSE (once per index scan). The new feature has us
> show pages deleted by the VACUUM that actually ran (not some earlier
> VACUUM) -- these are "newly deleted pages".
> 
> I don't think that this item is worth mentioning, though -- it's just
> a nice to have. If Bruce removes it from the release notes entirely I
> won't object.

OK, removed.  Additional debug output usually isn't important
mentioning --- when you need it, you will see it.

> In addition to the items that I commented on in my response to
> Matthias just now, I should point out the following item as worthy of
> inclusion:
> 
> 9dd963ae25 Recycle nbtree pages deleted during same VACUUM.
> 
> I suggest that this item be phrased more or less as follows:
> 
> "Allow VACUUM to eagerly place newly deleted B-Tree pages in the Free
> Space Map. Previously VACUUM could only place preexisting deleted
> pages in the Free Space Map for recycling."

So, previously it could only place pages that were deleted from the
previous vacuum on the free list?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

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