Re: Horribly slow pg_upgrade performance with many Large Objects

From:	Nathan Bossart <nathandbossart(at)gmail(dot)com>
To:	Nitin Motiani <nitinmotiani(at)google(dot)com>
Cc:	Hannu Krosing <hannuk(at)google(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: Horribly slow pg_upgrade performance with many Large Objects
Date:	2025-07-14 16:24:14
Message-ID:	aHUvLi_sdfBrxzYh@nathan
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2025-04-07 20:33:47 from Hannu Krosing <hannuk(at)google(dot)com>  2025-04-07 21:25:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2025-04-08 04:52:12 from Michael Paquier <michael(at)paquier(dot)xyz>    2025-04-08 07:15:45 from Hannu Krosing <hannuk(at)google(dot)com>     2025-04-08 07:26:02 from Hannu Krosing <hannuk(at)google(dot)com>  2025-04-07 22:17:03 from Nathan Bossart <nathandbossart(at)gmail(dot)com>   2025-04-08 07:35:24 from Hannu Krosing <hannuk(at)google(dot)com>    2025-04-08 15:46:41 from Nathan Bossart <nathandbossart(at)gmail(dot)com>     2025-04-08 16:13:28 from Hannu Krosing <hannuk(at)google(dot)com>     2025-04-08 16:13:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2025-04-08 16:20:06 from Hannu Krosing <hannuk(at)google(dot)com>       2025-04-08 16:37:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2025-04-08 16:50:01 from Nathan Bossart <nathandbossart(at)gmail(dot)com>         2025-04-08 17:07:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2025-04-08 17:18:31 from Hannu Krosing <hannuk(at)google(dot)com>           2025-04-08 17:22:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2025-04-08 17:36:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2025-04-08 17:41:26 from Nathan Bossart <nathandbossart(at)gmail(dot)com>             2025-04-08 17:51:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2025-04-09 17:16:44 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎          2025-04-08 17:22:00 from Nathan Bossart <nathandbossart(at)gmail(dot)com>           2025-04-08 17:42:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2025-04-08 18:39:45 from Nathan Bossart <nathandbossart(at)gmail(dot)com>             2025-04-08 19:41:06 from Hannu Krosing <hannuk(at)google(dot)com>              2025-04-08 21:37:50 from Jan Wieck <jan(at)wi3ck(dot)info>               2025-04-09 17:04:21 from Nathan Bossart <nathandbossart(at)gmail(dot)com>              2025-04-09 17:17:32 from Nathan Bossart <nathandbossart(at)gmail(dot)com>           2025-04-11 20:11:53 from Nathan Bossart <nathandbossart(at)gmail(dot)com>            2025-04-13 20:17:59 from Hannu Krosing <hannuk(at)google(dot)com>          2025-05-05 19:23:25 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎           2025-05-07 14:51:19 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎            2025-07-06 12:48:08 from Hannu Krosing <hannuk(at)google(dot)com>             2025-07-08 21:06:16 from Nathan Bossart <nathandbossart(at)gmail(dot)com>              2025-07-09 14:52:16 from Hannu Krosing <hannuk(at)google(dot)com>               2025-07-09 17:53:48 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                2025-07-09 21:13:38 from Hannu Krosing <hannuk(at)google(dot)com>                 2025-07-10 12:35:26 from Nitin Motiani <nitinmotiani(at)google(dot)com>                  2025-07-10 21:42:23 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                   2025-07-11 14:19:47 from Nitin Motiani <nitinmotiani(at)google(dot)com>                    2025-07-11 14:51:40 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                     2025-07-11 15:47:00 from Nitin Motiani <nitinmotiani(at)google(dot)com>                      2025-07-14 16:24:14 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                       2025-07-14 17:28:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2025-07-14 17:51:20 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                         2025-07-18 16:05:04 from Nathan Bossart <nathandbossart(at)gmail(dot)com>        2025-04-08 16:52:45 from Hannu Krosing <hannuk(at)google(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v4-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch	text/plain	11.0 KB

In response to

• Re: Horribly slow pg_upgrade performance with many Large Objects at 2025-07-11 15:47:00 from Nitin Motiani

Responses

• Re: Horribly slow pg_upgrade performance with many Large Objects at 2025-07-14 17:28:03 from Tom Lane

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Dmitry Dolgov	2025-07-14 16:32:35	Re: Changing shared_buffers without restart
Previous Message	Fujii Masao	2025-07-14 16:06:11	Re: Log prefix missing for subscriber log messages received from publisher