XMLWordPrintable

      PostgreSQL 19 Beta 1 already available: https://hub.docker.com/_/postgres/tags?name=19

      https://www.postgresql.org/about/news/postgresql-19-beta-1-released-3313/

       

      Please don't forget to modify systemd unit files to include dependencies for version 19 and also 

      adjust monitoring templates:

      PostgreSQL 19 introduces the pg_stat_lock view, which reports per-lock-type statistics, and pg_stat_recovery which provides detailed visibility into the state of recovery operations. A stats_reset column is now available across many statistics views to show when counters were last cleared. The pg_stat_progress_vacuum and pg_stat_progress_analyze views now include a started_by column that reports the initiator of the operation, and pg_stat_progress_vacuum also has a mode column that reports how vacuum is operating.

      This release also allows log_min_messages levels to be specified per process type, giving operators finer control over what each part of the system logs. Additionally, WAL full page write byte counts are now reported in VACUUM and ANALYZE log output, helping identify maintenance operations that generate large amounts of WAL. Additionally, EXPLAIN ANALYZE now supports surfacing asynchronous I/O (AIO) statistics through its IO option, providing better visibility into how queries are using the AIO subsystem.

       

            Assignee:
            Vladislavs Sokurenko
            Reporter:
            Edgar Akhmetshin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: