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>, Masahiko Sawada <sawada.mshk@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2021-05-18T15:57:11Z
Lists: pgsql-hackers 
On Tue, May 18, 2021 at 08:54:56AM -0700, Peter Geoghegan wrote:
> On Tue, May 18, 2021 at 8:48 AM Bruce Momjian <bruce@momjian.us> wrote:
> > I am thiking the vacuum_cleanup_index_scale_factor existance in a PG 14
> > postgresql.conf will throw an error, unlike 13.x, so I do think we need
> > to mention this so people will know to remove it from their
> > postgresql.conf before upgrades, right?  I don't think the PG 13.3
> > release note mention really makes it clear it has to be removed.  In a
> > dump/restore, so we retain the reloption
> > vacuum_cleanup_index_scale_factor and just ignore it, or drop it on
> > restore?  I am hoping it is the later.
> 
> There is no dump/restore hazard on upgrade to 14, since the
> vacuum_cleanup_index_scale_factor reloption remains in place (it's
> just not in psql tab completion anymore, nor is it documented, etc).

So it is the former behavior --- "so we retain the reloption
vacuum_cleanup_index_scale_factor and just ignore it"?

> It is possible (though I would certainly say unlikely) that the
> vacuum_cleanup_index_scale_factor GUC will be in somebody's
> postgresql.conf from an earlier version, and won't be recognized on
> upgrade to v14. So maybe you need to say something about that
> particular issue -- which could be framed as finishing off the process
> started by the 13.3 commit. But that's it.

Yes.

-- 
  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