Home > mailing lists

Re: regarding statistics retaining with 18 Upgrade - Mailing list pgsql-hackers

From	Rambabu V
Subject	Re: regarding statistics retaining with 18 Upgrade
Date	November 16 08:03:30
Msg-id	CADtiZxqvRjSF+9bu6E_gZ-5hma0G7-_5eH+U=wfYDvU-H1ACtA@mail.gmail.com Whole thread Raw
In response to	Re: regarding statistics retaining with 18 Upgrade (Dilip Kumar <dilipbalaut@gmail.com>)
List	pgsql-hackers

Tree view

Thanks all for the proactive response and clarification.

people will be confused by seeing the release notes, it should be a little bit clear or need to update.

i have one more question :

with every version of package installation , PG 17 version is getting by default installed, is it a hard dependency or bug?

[root@db1 ~]# dnf install -y postgresql16-server postgresql16-contrib -y
Updating Subscription Management repositories.
Unable to read consumer identity

This system is not registered with an entitlement server. You can use "rhc" or "subscription-manager" to register.

Last metadata expiration check: 0:05:28 ago on Sun Nov 16 04:56:13 2025.
Dependencies resolved.
====================================================================================================================================================================================================================
Package Architecture Version Repository Size
====================================================================================================================================================================================================================
Installing:
postgresql16-contrib x86_64 16.11-1PGDG.rhel10 pgdg16 730 k
postgresql16-server x86_64 16.11-1PGDG.rhel10 pgdg16 6.8 M
Installing dependencies:
libicu x86_64 74.2-5.el10_0 rhel-10-baseos-rhui-rpms 10 M
libxslt x86_64 1.1.39-8.el10_0 rhel-10-appstream-rhui-rpms 190 k
postgresql16 x86_64 16.11-1PGDG.rhel10 pgdg16 1.8 M
postgresql16-libs x86_64 16.11-1PGDG.rhel10 pgdg16 339 k
postgresql17 x86_64 17.7-1PGDG.rhel10 pgdg17 1.9 M
postgresql17-libs x86_64 17.7-1PGDG.rhel10 pgdg17 346 k
Installing weak dependencies:
postgresql17-server x86_64 17.7-1PGDG.rhel10 pgdg17 7.0 M

Transaction Summary
====================================================================================================================================================================================================================
Install 9 Packages

Total download size: 30 M
Installed size: 120 M
Downloading Packages:
(1/9): postgresql17-libs-17.7-1PGDG.rhel10.x86_64.rpm 11 MB/s | 346 kB 00:00
(2/9): postgresql17-17.7-1PGDG.rhel10.x86_64.rpm 42 MB/s | 1.9 MB 00:00
(3/9): postgresql16-16.11-1PGDG.rhel10.x86_64.rpm 56 MB/s | 1.8 MB 00:00
(4/9): postgresql16-contrib-16.11-1PGDG.rhel10.x86_64.rpm 25 MB/s | 730 kB 00:00
(5/9): postgresql16-libs-16.11-1PGDG.rhel10.x86_64.rpm 20 MB/s | 339 kB 00:00
(6/9): libxslt-1.1.39-8.el10_0.x86_64.rpm 6.6 MB/s | 190 kB 00:00
(7/9): libicu-74.2-5.el10_0.x86_64.rpm 104 MB/s | 10 MB 00:00
(8/9): postgresql17-server-17.7-1PGDG.rhel10.x86_64.rpm 28 MB/s | 7.0 MB 00:00
(9/9): postgresql16-server-16.11-1PGDG.rhel10.x86_64.rpm 33 MB/s | 6.8 MB 00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 92 MB/s | 30 MB 00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : postgresql17-libs-17.7-1PGDG.rhel10.x86_64 1/9
Running scriptlet: postgresql17-libs-17.7-1PGDG.rhel10.x86_64 1/9
Installing : libicu-74.2-5.el10_0.x86_64 2/9
Installing : postgresql16-libs-16.11-1PGDG.rhel10.x86_64 3/9
Running scriptlet: postgresql16-libs-16.11-1PGDG.rhel10.x86_64 3/9
Installing : postgresql16-16.11-1PGDG.rhel10.x86_64 4/9
Running scriptlet: postgresql16-16.11-1PGDG.rhel10.x86_64 4/9
Installing : postgresql17-17.7-1PGDG.rhel10.x86_64 5/9
Running scriptlet: postgresql17-17.7-1PGDG.rhel10.x86_64 5/9
Running scriptlet: postgresql17-server-17.7-1PGDG.rhel10.x86_64 6/9
Installing : postgresql17-server-17.7-1PGDG.rhel10.x86_64 6/9
Running scriptlet: postgresql17-server-17.7-1PGDG.rhel10.x86_64 6/9
Running scriptlet: postgresql16-server-16.11-1PGDG.rhel10.x86_64 7/9
Installing : postgresql16-server-16.11-1PGDG.rhel10.x86_64 7/9
Running scriptlet: postgresql16-server-16.11-1PGDG.rhel10.x86_64 7/9
Installing : libxslt-1.1.39-8.el10_0.x86_64 8/9
Installing : postgresql16-contrib-16.11-1PGDG.rhel10.x86_64 9/9
Running scriptlet: postgresql16-contrib-16.11-1PGDG.rhel10.x86_64 9/9
Installed products updated.

Installed:
libicu-74.2-5.el10_0.x86_64 libxslt-1.1.39-8.el10_0.x86_64 postgresql16-16.11-1PGDG.rhel10.x86_64 postgresql16-contrib-16.11-1PGDG.rhel10.x86_64
postgresql16-libs-16.11-1PGDG.rhel10.x86_64 postgresql16-server-16.11-1PGDG.rhel10.x86_64 postgresql17-17.7-1PGDG.rhel10.x86_64 postgresql17-libs-17.7-1PGDG.rhel10.x86_64
postgresql17-server-17.7-1PGDG.rhel10.x86_64

Complete!
[root@db1 ~]# rpm -qa|grep postgres
postgresql17-libs-17.7-1PGDG.rhel10.x86_64
postgresql16-libs-16.11-1PGDG.rhel10.x86_64
postgresql16-16.11-1PGDG.rhel10.x86_64
postgresql17-17.7-1PGDG.rhel10.x86_64
postgresql17-server-17.7-1PGDG.rhel10.x86_64
postgresql16-server-16.11-1PGDG.rhel10.x86_64
postgresql16-contrib-16.11-1PGDG.rhel10.x86_64

On Sun, Nov 16, 2025 at 12:43 PM Dilip Kumar <dilipbalaut@gmail.com> wrote:

On Sun, Nov 16, 2025 at 5:22 AM Robert Treat <rob@xzilla.net> wrote:
>
> On Sat, Nov 15, 2025 at 9:32 AM Bruce Momjian <bruce@momjian.us> wrote:
> > On Sat, Nov 15, 2025 at 06:02:53PM +0800, Rambabu V wrote:
> > > Hi Team,
> > >
> > > seems stats are not retained after upgrade. Below are the artifacts , is it
> > > expected? as per the release notes statistics should be retained.
> >
> > Uh, it is the _optimizer_ statistics that are preserved by pg_upgrade,
> > not the cumulative statistics system:
> >
> > https://www.postgresql.org/docs/current/monitoring-stats.html
> >
> > Yes, they are easily confused.
> >
>
> I wonder if it might be worth trying to clarify this a little bit
> more... perhaps something like the attached?

IMHO it makes sense to update the doc as you suggested to avoid any confusion.

--
Regards,
Dilip Kumar
Google

pgsql-hackers by date:

From: Dilip Kumar
Date: 16 November, 07:43:40
Subject: Re: regarding statistics retaining with 18 Upgrade

From: Alexander Korotkov
Date: 16 November, 15:08:58
Subject: Re: Implement waiting for wal lsn replay: reloaded

Re: regarding statistics retaining with 18 Upgrade - Mailing list pgsql-hackers

Previous

Next