| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
| Cc: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, jian he <jian(dot)universality(at)gmail(dot)com>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net>, Stephen Frost <sfrost(at)snowman(dot)net>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, alvherre(at)alvh(dot)no-ip(dot)org |
| Subject: | Re: Statistics Import and Export |
| Date: | 2025-02-21 20:23:00 |
| Message-ID: | sdno5atrplq5b67vcx7x6fkzevwkzojd23izbguy2yma424wmp@siwbi3ijxdxs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On 2025-02-20 01:39:34 -0800, Jeff Davis wrote:
> Committed with some revisions on top of v48:
This made the pg_upgrade tests considerably slower.
In an assert build without optimization (since that's what I use for normal
dev work):
1fd1bd87101^ 65.03s
1fd1bd87101 86.84s
Looking at the times in the in the regress_log, I see:
good: [15:17:31.278](36.851s) ok 5 - regression tests pass
bad: [15:15:37.857](37.437s) ok 5 - regression tests pass
good: [15:17:36.721](5.436s) ok 6 - dump before running pg_upgrade
bad: [15:15:50.845](12.980s) ok 6 - dump before running pg_upgrade
good: [15:17:39.759](2.441s) ok 12 - run of pg_upgrade --check for new instance
bad: [15:15:53.861](2.415s) ok 12 - run of pg_upgrade --check for new instance
good: [15:17:51.249](11.489s) ok 14 - run of pg_upgrade for new instance
bad: [15:16:13.304](19.443s) ok 14 - run of pg_upgrade for new instance
good: [15:17:55.382](3.958s) ok 17 - dump after running pg_upgrade
bad: [15:16:23.766](10.290s) ok 17 - dump after running pg_upgrade
Which to me rather strongly suggests pg_dump has gotten a *lot* slower with
this change.
Greetings,
Andres
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-02-21 20:33:26 | Re: Psql meta-command conninfo+ |
| Previous Message | Mark Dilger | 2025-02-21 20:16:25 | Re: Amcheck verification of GiST and GIN |