Re: Improving connection scalability: GetSnapshotData()

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Andres Freund <andres(at)anarazel(dot)de>
Cc:	Robert Haas <robertmhaas(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>, Bruce Momjian <bruce(at)momjian(dot)us>, David Rowley <dgrowleyml(at)gmail(dot)com>
Subject:	Re: Improving connection scalability: GetSnapshotData()
Date:	2020-08-16 20:17:23
Message-ID:	1013484.1597609043@sss.pgh.pa.us
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2020-03-01 08:36:01 from Andres Freund <andres(at)anarazel(dot)de> 📎  2020-03-01 08:46:38 from Andres Freund <andres(at)anarazel(dot)de> 📎   2020-03-01 10:55:52 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>   2020-04-05 12:05:12 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎  2020-03-02 23:24:21 from Andres Freund <andres(at)anarazel(dot)de> 📎  2020-03-04 14:04:08 from David Steele <david(at)pgmasters(dot)net>  2020-03-17 10:59:14 from David Rowley <dgrowleyml(at)gmail(dot)com>   2020-03-29 00:49:20 from Andres Freund <andres(at)anarazel(dot)de>    2020-03-29 01:15:09 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>  2020-03-20 05:23:03 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>   2020-03-20 06:00:45 from Andres Freund <andres(at)anarazel(dot)de>  2020-03-29 01:39:32 from Peter Geoghegan <pg(at)bowt(dot)ie>   2020-03-29 01:44:02 from Bruce Momjian <bruce(at)momjian(dot)us>   2020-03-29 03:35:22 from Andres Freund <andres(at)anarazel(dot)de>    2020-03-31 20:04:38 from Andres Freund <andres(at)anarazel(dot)de>     2020-03-31 21:55:36 from Andres Freund <andres(at)anarazel(dot)de>   2020-03-29 18:24:32 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>    2020-03-29 18:50:10 from Andres Freund <andres(at)anarazel(dot)de>     2020-03-29 22:52:43 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>     2020-03-30 14:04:00 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>      2020-04-06 13:39:59 from Andres Freund <andres(at)anarazel(dot)de>       2020-04-06 20:53:29 from Andres Freund <andres(at)anarazel(dot)de>       2020-04-06 23:52:28 from Andres Freund <andres(at)anarazel(dot)de>        2020-04-07 12:15:03 from Andres Freund <andres(at)anarazel(dot)de> 📎         2020-04-07 12:18:51 from Andres Freund <andres(at)anarazel(dot)de> 📎         2020-04-07 14:27:11 from "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>         2020-04-07 16:41:07 from Robert Haas <robertmhaas(at)gmail(dot)com>          2020-04-07 17:51:12 from Andres Freund <andres(at)anarazel(dot)de>           2020-04-07 18:28:09 from Robert Haas <robertmhaas(at)gmail(dot)com>            2020-04-07 19:24:53 from Andres Freund <andres(at)anarazel(dot)de>             2020-04-07 20:13:07 from Robert Haas <robertmhaas(at)gmail(dot)com>              2020-04-07 20:42:10 from Andres Freund <andres(at)anarazel(dot)de>            2020-04-07 19:26:36 from Robert Haas <robertmhaas(at)gmail(dot)com>             2020-04-07 20:27:21 from Andres Freund <andres(at)anarazel(dot)de>              2020-04-08 13:24:13 from Robert Haas <robertmhaas(at)gmail(dot)com>               2020-04-08 21:37:55 from Andres Freund <andres(at)anarazel(dot)de>           2020-04-07 18:28:52 from Andres Freund <andres(at)anarazel(dot)de>            2020-04-07 18:32:42 from Peter Geoghegan <pg(at)bowt(dot)ie>            2020-04-07 18:51:52 from Robert Haas <robertmhaas(at)gmail(dot)com>             2020-04-07 19:30:55 from Andres Freund <andres(at)anarazel(dot)de>              2020-04-07 20:08:54 from Robert Haas <robertmhaas(at)gmail(dot)com>           2020-04-07 19:03:46 from Robert Haas <robertmhaas(at)gmail(dot)com>            2020-04-07 19:43:27 from Andres Freund <andres(at)anarazel(dot)de>         2020-04-08 12:43:18 from Andres Freund <andres(at)anarazel(dot)de> 📎          2020-04-08 12:59:50 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>           2020-04-08 13:26:42 from "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>            2020-04-08 13:44:16 from Robert Haas <robertmhaas(at)gmail(dot)com>             2020-04-08 22:06:23 from Bruce Momjian <bruce(at)momjian(dot)us>              2020-04-08 22:25:34 from Andres Freund <andres(at)anarazel(dot)de>               2020-04-09 00:31:56 from Bruce Momjian <bruce(at)momjian(dot)us>             2020-04-08 22:20:17 from Andres Freund <andres(at)anarazel(dot)de>              2020-07-01 12:42:59 from Daniel Gustafsson <daniel(at)yesql(dot)se>               2020-07-16 01:25:32 from Andres Freund <andres(at)anarazel(dot)de> 📎                2020-07-16 01:33:06 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                 2020-07-24 01:11:43 from Andres Freund <andres(at)anarazel(dot)de> 📎                  2020-07-29 06:15:30 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                   2020-07-29 07:20:04 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                    2020-08-12 00:19:38 from Andres Freund <andres(at)anarazel(dot)de>                     2020-08-12 00:24:52 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                      2020-08-12 17:38:55 from Andres Freund <andres(at)anarazel(dot)de> 📎                       2020-08-15 15:10:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2020-08-15 16:42:00 from Andres Freund <andres(at)anarazel(dot)de>                         2020-08-16 18:16:04 from Andres Freund <andres(at)anarazel(dot)de>                          2020-08-16 18:30:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                           2020-08-16 19:00:12 from Andres Freund <andres(at)anarazel(dot)de>                           2020-08-16 20:17:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                            2020-08-16 20:31:53 from Andres Freund <andres(at)anarazel(dot)de>                             2020-08-16 20:52:58 from Andres Freund <andres(at)anarazel(dot)de>                              2020-08-16 21:11:46 from Andres Freund <andres(at)anarazel(dot)de>                               2020-08-16 21:26:57 from Andres Freund <andres(at)anarazel(dot)de>                                2020-09-03 08:18:29 from Michael Paquier <michael(at)paquier(dot)xyz>                                 2020-09-04 15:24:12 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                  2020-09-04 18:53:04 from Andres Freund <andres(at)anarazel(dot)de>                                   2020-09-04 19:11:31 from Andres Freund <andres(at)anarazel(dot)de> 📎                                   2020-09-05 13:58:31 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                    2020-09-06 18:52:14 from Andres Freund <andres(at)anarazel(dot)de>                                     2020-09-07 16:35:50 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                   2020-09-06 11:05:35 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                    2020-09-06 18:56:19 from Andres Freund <andres(at)anarazel(dot)de>                                     2020-09-07 14:20:53 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> 📎                                      2020-09-07 20:45:48 from "Andres Freund" <andres(at)anarazel(dot)de>                                       2020-09-08 09:27:35 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                 2020-09-04 17:35:19 from Andres Freund <andres(at)anarazel(dot)de>                                  2020-09-05 01:31:24 from Michael Paquier <michael(at)paquier(dot)xyz>                                 2020-09-08 04:03:01 from Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com>                                  2020-09-08 04:11:14 from Andres Freund <andres(at)anarazel(dot)de>                                   2020-09-08 04:23:01 from Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com>                                    2020-09-09 08:02:58 from Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com> 📎                                     2020-09-14 23:17:18 from Andres Freund <andres(at)anarazel(dot)de> 📎                                      2020-09-15 00:14:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                       2020-09-15 00:42:51 from Andres Freund <andres(at)anarazel(dot)de>                                        2020-09-15 02:56:24 from Michael Paquier <michael(at)paquier(dot)xyz>                                         2020-09-15 03:03:34 from Andres Freund <andres(at)anarazel(dot)de>                                      2020-09-30 22:43:17 from Andres Freund <andres(at)anarazel(dot)de> 📎                                       2020-10-01 18:26:30 from Andres Freund <andres(at)anarazel(dot)de>                                        2020-10-01 20:00:20 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                                         2020-10-01 20:22:01 from Andres Freund <andres(at)anarazel(dot)de>                                          2020-10-01 20:44:03 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                                           2020-10-01 20:59:54 from Andres Freund <andres(at)anarazel(dot)de>                                          2020-10-01 23:21:14 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                                           2020-10-06 02:33:50 from Andres Freund <andres(at)anarazel(dot)de>                                            2020-10-09 20:38:14 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                        2020-10-02 02:14:19 from Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com>                                      2020-10-01 09:37:34 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                   2020-09-08 04:44:17 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                    2020-09-08 17:53:52 from Andres Freund <andres(at)anarazel(dot)de>                                     2020-09-09 06:28:07 from Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com> 📎                               2020-08-16 21:28:02 from Peter Geoghegan <pg(at)bowt(dot)ie>                                2020-08-17 20:09:40 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                               2020-08-16 21:28:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                2020-08-16 21:30:46 from Andres Freund <andres(at)anarazel(dot)de>                  2020-07-31 19:43:50 from Daniel Gustafsson <daniel(at)yesql(dot)se>            2020-04-08 22:17:41 from Andres Freund <andres(at)anarazel(dot)de>             2020-04-09 01:22:04 from Michael Paquier <michael(at)paquier(dot)xyz>              2020-06-07 08:24:50 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>               2020-09-08 19:19:01 from Andres Freund <andres(at)anarazel(dot)de>  2021-02-27 17:40:58 from AJG <ayden(at)gera(dot)co(dot)nz>   2021-03-01 12:49:47 from luis(dot)roberto(at)siscobra(dot)com(dot)br   2021-03-01 15:46:51 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
add-delay-before-vacuum.patch	text/x-diff	1.1 KB

In response to

• Re: Improving connection scalability: GetSnapshotData() at 2020-08-16 18:30:24 from Tom Lane

Responses

• Re: Improving connection scalability: GetSnapshotData() at 2020-08-16 20:31:53 from Andres Freund

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2020-08-16 20:31:53	Re: Improving connection scalability: GetSnapshotData()
Previous Message	Paul A Jungwirth	2020-08-16 19:55:21	Re: range_agg