Re: Performance degradation on concurrent COPY into a single relation in PG16.

From:	Andres Freund <andres(at)anarazel(dot)de>
To:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc:	Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Peter Eisentraut <peter(at)eisentraut(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: Performance degradation on concurrent COPY into a single relation in PG16.
Date:	2023-08-16 22:54:32
Message-ID:	20230816225432.fibahevlqsssj2hv@awork3.anarazel.de
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2023-07-03 02:55:13 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎  2023-07-03 02:59:38 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎   2023-07-03 07:36:49 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>    2023-07-03 07:54:16 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>     2023-07-03 09:53:56 from Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>      2023-07-10 16:24:15 from Andres Freund <andres(at)anarazel(dot)de>       2023-07-11 02:32:59 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>       2023-07-11 07:09:43 from Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>        2023-07-11 15:47:33 from Andres Freund <andres(at)anarazel(dot)de>   2023-07-10 15:44:39 from Andres Freund <andres(at)anarazel(dot)de>  2023-07-10 13:25:41 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>   2023-07-10 15:28:25 from Andres Freund <andres(at)anarazel(dot)de>  2023-07-10 15:34:45 from Andres Freund <andres(at)anarazel(dot)de>   2023-07-11 02:02:51 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>  2023-07-11 18:51:59 from Andres Freund <andres(at)anarazel(dot)de>   2023-07-12 08:40:20 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎    2023-07-19 08:24:13 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> 📎     2023-07-19 11:13:48 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>      2023-07-19 23:56:25 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎       2023-07-20 08:36:48 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> 📎        2023-07-20 22:35:05 from David Rowley <dgrowleyml(at)gmail(dot)com>        2023-07-25 05:34:36 from Andres Freund <andres(at)anarazel(dot)de>         2023-07-25 11:37:08 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎          2023-07-25 15:50:19 from Andres Freund <andres(at)anarazel(dot)de> 📎           2023-07-25 16:06:35 from Andres Freund <andres(at)anarazel(dot)de>           2023-07-27 00:17:20 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎            2023-07-31 09:39:04 from John Naylor <john(dot)naylor(at)enterprisedb(dot)com>             2023-08-01 12:21:42 from David Rowley <dgrowleyml(at)gmail(dot)com>           2023-07-27 02:51:20 from David Rowley <dgrowleyml(at)gmail(dot)com>            2023-07-27 08:53:16 from David Rowley <dgrowleyml(at)gmail(dot)com>             2023-08-01 01:25:30 from Andres Freund <andres(at)anarazel(dot)de>              2023-08-01 12:55:13 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎               2023-08-01 13:25:51 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                2023-08-01 14:00:47 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                 2023-08-01 19:38:12 from Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>                  2023-08-02 00:25:35 from David Rowley <dgrowleyml(at)gmail(dot)com>                   2023-08-02 01:35:49 from David Rowley <dgrowleyml(at)gmail(dot)com>                    2023-08-07 06:16:19 from David Rowley <dgrowleyml(at)gmail(dot)com>                     2023-08-07 14:05:39 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                      2023-08-07 18:10:26 from Andres Freund <andres(at)anarazel(dot)de> 📎                       2023-08-08 03:45:05 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                        2023-08-12 20:05:04 from Andres Freund <andres(at)anarazel(dot)de> 📎                         2023-08-16 11:15:46 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                          2023-08-16 22:54:32 from Andres Freund <andres(at)anarazel(dot)de>                           2023-09-06 22:01:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2023-09-16 00:00:11 from Andres Freund <andres(at)anarazel(dot)de>                             2023-09-25 19:42:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                              2023-09-25 19:48:30 from Andres Freund <andres(at)anarazel(dot)de>                               2023-09-25 21:37:46 from Andres Freund <andres(at)anarazel(dot)de>                                2023-10-12 15:44:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                 2023-10-12 16:24:19 from Andres Freund <andres(at)anarazel(dot)de>                                  2023-10-13 17:39:10 from Andres Freund <andres(at)anarazel(dot)de>                                   2023-10-13 18:30:35 from Andres Freund <andres(at)anarazel(dot)de> 📎                                    2023-10-14 02:33:44 from Andres Freund <andres(at)anarazel(dot)de>
Lists:	pgsql-hackers

In response to

• Re: Performance degradation on concurrent COPY into a single relation in PG16. at 2023-08-16 11:15:46 from Alvaro Herrera

Responses

• Re: Performance degradation on concurrent COPY into a single relation in PG16. at 2023-09-06 22:01:53 from Tom Lane

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Thomas Munro	2023-08-16 22:58:45	Re: walsender "wakeup storm" on PG16, likely because of bc971f4025c (Optimize walsender wake up logic using condition variables)
Previous Message	Andres Freund	2023-08-16 22:49:49	Re: Rename ExtendedBufferWhat in 16?