Re: regarding statistics retaining with 18 Upgrade

2025-11-19 Thread Fujii Masao
On Wed, Nov 19, 2025 at 1:00 AM Bruce Momjian wrote: > Yeah, you are probably right. I didn't see that. You should apply it > since it is your patch, thanks. Okay, so barring any objection, I will commit the attached patch. Regards, -- Fujii Masao v1-0001-doc-Update-pg_upgrade-documentatio

Re: regarding statistics retaining with 18 Upgrade

2025-11-18 Thread Bruce Momjian
On Tue, Nov 18, 2025 at 12:41:28PM +0900, Fujii Masao wrote: > On Tue, Nov 18, 2025 at 8:56 AM Bruce Momjian wrote: > > > > On Sat, Nov 15, 2025 at 06:52:15PM -0500, Robert Treat wrote: > > > On Sat, Nov 15, 2025 at 9:32 AM Bruce Momjian wrote: > > > > On Sat, Nov 15, 2025 at 06:02:53PM +0800, Ra

Re: regarding statistics retaining with 18 Upgrade

2025-11-17 Thread Fujii Masao
On Tue, Nov 18, 2025 at 8:56 AM Bruce Momjian wrote: > > On Sat, Nov 15, 2025 at 06:52:15PM -0500, Robert Treat wrote: > > On Sat, Nov 15, 2025 at 9:32 AM Bruce Momjian wrote: > > > On Sat, Nov 15, 2025 at 06:02:53PM +0800, Rambabu V wrote: > > > > Hi Team, > > > > > > > > seems stats are not ret

Re: regarding statistics retaining with 18 Upgrade

2025-11-17 Thread Bruce Momjian
On Sat, Nov 15, 2025 at 06:52:15PM -0500, Robert Treat wrote: > On Sat, Nov 15, 2025 at 9:32 AM Bruce Momjian 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 > > > ex

Re: regarding statistics retaining with 18 Upgrade

2025-11-17 Thread Bruce Momjian
On Sun, Nov 16, 2025 at 01:03:30PM +0800, Rambabu V wrote: > 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. Yes, the release notes are clear, but the non-release docs are not.

Re: regarding statistics retaining with 18 Upgrade

2025-11-15 Thread Rambabu V
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 dep

Re: regarding statistics retaining with 18 Upgrade

2025-11-15 Thread Dilip Kumar
On Sun, Nov 16, 2025 at 5:22 AM Robert Treat wrote: > > On Sat, Nov 15, 2025 at 9:32 AM Bruce Momjian 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?

Re: regarding statistics retaining with 18 Upgrade

2025-11-15 Thread Robert Treat
On Sat, Nov 15, 2025 at 9:32 AM Bruce Momjian 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

Re: regarding statistics retaining with 18 Upgrade

2025-11-15 Thread Greg Sabino Mullane
On Sat, Nov 15, 2025 at 9:32 AM Bruce Momjian wrote: > Uh, it is the _optimizer_ statistics that are preserved by pg_upgrade, > Specifically, check out the pg_stats view. Try this on your new cluster: select count(distinct tablename) from pg_stats where tablename !~ 'pg_|sql_'; Cheers, Greg -

Re: regarding statistics retaining with 18 Upgrade

2025-11-15 Thread Bruce Momjian
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

regarding statistics retaining with 18 Upgrade

2025-11-15 Thread Rambabu V
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. before upgrade: postgres=# select * from pg_stat_user_tables; -[ RECORD 1 ]---+-- relid | 16384