Re: Inefficiency in parallel pg_restore with many tables

From:	Nathan Bossart <nathandbossart(at)gmail(dot)com>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:	Robert Haas <robertmhaas(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject:	Re: Inefficiency in parallel pg_restore with many tables
Date:	2023-09-18 21:22:32
Message-ID:	20230918212232.GA2660216@nathanxps13
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2023-07-15 17:47:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>  2023-07-15 18:19:16 from Andres Freund <andres(at)anarazel(dot)de>  2023-07-16 12:17:49 from Andrew Dunstan <andrew(at)dunslane(dot)net>   2023-07-16 13:45:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2023-07-17 03:54:24 from Nathan Bossart <nathandbossart(at)gmail(dot)com>     2023-07-18 04:57:01 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎      2023-07-18 16:05:11 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>       2023-07-18 16:07:13 from Nathan Bossart <nathandbossart(at)gmail(dot)com>        2023-07-20 19:06:44 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎         2023-07-22 23:19:41 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎          2023-07-22 23:28:15 from Nathan Bossart <nathandbossart(at)gmail(dot)com>          2023-07-22 23:47:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2023-07-23 05:57:03 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎            2023-07-24 19:00:15 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎             2023-07-25 18:53:36 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎              2023-09-01 17:05:46 from Nathan Bossart <nathandbossart(at)gmail(dot)com>               2023-09-01 17:41:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2023-09-01 17:51:29 from Nathan Bossart <nathandbossart(at)gmail(dot)com>              2023-09-01 20:00:44 from Robert Haas <robertmhaas(at)gmail(dot)com>               2023-09-01 20:52:48 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                2023-09-02 18:55:21 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                 2023-09-03 10:04:00 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                  2023-09-03 15:11:16 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                 2023-09-04 23:08:29 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                  2023-09-10 16:35:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2023-09-13 18:34:50 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                    2023-09-13 22:47:53 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                     2023-09-14 00:01:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2023-09-14 03:45:39 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                       2023-09-18 21:22:32 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                        2023-09-19 01:23:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2023-09-19 01:28:58 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                          2023-09-19 01:36:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                           2023-09-19 01:54:28 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                         2023-09-19 01:29:09 from Michael Paquier <michael(at)paquier(dot)xyz>                        2023-09-20 02:30:33 from Nathan Bossart <nathandbossart(at)gmail(dot)com>  2023-07-24 17:27:36 from Pierre Ducroquet <p(dot)psql(at)pinaraf(dot)info>
Lists:	pgsql-hackers

In response to

• Re: Inefficiency in parallel pg_restore with many tables at 2023-09-14 03:45:39 from Nathan Bossart

Responses

• Re: Inefficiency in parallel pg_restore with many tables at 2023-09-19 01:23:20 from Tom Lane
• Re: Inefficiency in parallel pg_restore with many tables at 2023-09-20 02:30:33 from Nathan Bossart

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Nathan Bossart	2023-09-18 21:52:47	Re: Improvements in pg_dump/pg_restore toc format and performances
Previous Message	Peter Smith	2023-09-18 21:18:44	Re: Add 'worker_type' to pg_stat_subscription