Re: Speedup twophase transactions

From:	Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>
To:	Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc:	pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Speedup twophase transactions
Date:	2016-01-09 12:26:27
Message-ID:	16B1C0AC-58B7-4C52-94BD-57FB16E926A9@postgrespro.ru
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2015-12-09 18:44:28 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎  2015-12-09 21:37:52 from Kevin Grittner <kgrittn(at)gmail(dot)com>   2015-12-09 22:10:34 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>  2015-12-09 23:16:19 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>   2015-12-10 12:41:39 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎  2015-12-10 06:48:26 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>  2015-12-10 19:47:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>   2016-01-08 16:29:32 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>    2016-01-09 12:26:27 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎     2016-01-09 15:29:11 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎      2016-01-09 20:28:32 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>       2016-01-10 09:15:11 from Simon Riggs <simon(at)2ndQuadrant(dot)com>        2016-01-11 12:58:09 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>         2016-01-11 18:43:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>          2016-01-11 19:57:58 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎           2016-01-11 20:10:45 from Andres Freund <andres(at)anarazel(dot)de>            2016-01-11 21:46:01 from Simon Riggs <simon(at)2ndQuadrant(dot)com>             2016-01-11 22:24:45 from Andres Freund <andres(at)anarazel(dot)de>              2016-01-12 04:28:51 from Simon Riggs <simon(at)2ndQuadrant(dot)com>           2016-01-12 06:35:55 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>            2016-01-12 06:41:29 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>             2016-01-12 08:26:32 from Simon Riggs <simon(at)2ndQuadrant(dot)com>              2016-01-12 12:49:38 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>            2016-01-12 08:21:44 from Simon Riggs <simon(at)2ndQuadrant(dot)com>             2016-01-12 12:53:25 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>              2016-01-12 15:56:46 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>               2016-01-12 19:53:59 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>              2016-01-12 20:30:39 from Simon Riggs <simon(at)2ndQuadrant(dot)com>        2016-01-11 18:51:03 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>         2016-01-11 19:20:59 from Simon Riggs <simon(at)2ndQuadrant(dot)com>      2016-01-11 18:40:03 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> 📎       2016-01-11 23:11:12 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>        2016-01-12 05:14:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com> 📎        2016-01-12 14:48:05 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> 📎      2016-01-11 19:03:18 from Andres Freund <andres(at)anarazel(dot)de>       2016-01-11 19:07:02 from Andres Freund <andres(at)anarazel(dot)de>        2016-01-11 19:16:55 from Simon Riggs <simon(at)2ndQuadrant(dot)com>       2016-01-11 19:15:23 from Simon Riggs <simon(at)2ndQuadrant(dot)com>        2016-01-11 19:18:29 from Andres Freund <andres(at)anarazel(dot)de>         2016-01-11 19:39:14 from Simon Riggs <simon(at)2ndQuadrant(dot)com>          2016-01-12 18:14:32 from Andres Freund <andres(at)anarazel(dot)de>           2016-01-12 19:57:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>            2016-01-26 12:43:42 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎             2016-01-26 17:20:30 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>              2016-01-26 20:39:15 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>               2016-01-27 01:31:41 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>               2016-03-16 23:39:22 from David Steele <david(at)pgmasters(dot)net>             2016-03-11 16:41:03 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>              2016-03-18 16:50:54 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎               2016-03-21 16:53:33 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                2016-03-22 13:20:53 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                 2016-03-29 15:04:46 from David Steele <david(at)pgmasters(dot)net>                 2016-03-30 13:19:01 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                  2016-03-30 18:08:05 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                  2016-04-01 07:04:32 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                   2016-04-01 13:53:28 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                    2016-04-02 00:14:24 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                     2016-04-06 09:47:18 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎                      2016-04-07 06:29:13 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com> 📎                       2016-04-08 12:49:16 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                        2016-04-08 18:37:55 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2016-04-08 18:57:00 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                          2016-04-09 02:10:43 from Noah Misch <noah(at)leadboat(dot)com>                       2016-04-08 13:09:23 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎                        2016-04-11 10:16:37 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎                         2016-04-12 12:47:40 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com> 📎                          2016-04-12 16:53:22 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                           2016-04-12 22:04:18 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                            2016-04-13 14:31:25 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎                             2016-05-20 12:48:46 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                              2016-05-20 16:46:49 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                               2016-05-20 17:08:23 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                             2016-09-01 20:06:55 from Simon Riggs <simon(at)2ndquadrant(dot)com>                              2016-09-03 13:26:21 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                               2016-09-06 01:41:27 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com> 📎                                2016-09-06 06:59:52 from Simon Riggs <simon(at)2ndquadrant(dot)com>                                2016-09-06 08:58:02 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                 2016-09-06 09:03:53 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                  2016-09-06 09:49:53 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                   2016-09-07 00:09:26 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                    2016-09-07 08:07:31 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                     2016-09-16 17:45:19 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎                                      2016-09-20 06:40:54 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                       2016-09-20 14:13:19 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                        2016-09-21 07:32:15 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                         2016-09-21 15:30:07 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                          2016-09-27 00:30:02 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                           2016-12-16 11:00:46 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                            2016-12-17 21:42:07 from Bruce Momjian <bruce(at)momjian(dot)us>                                             2016-12-17 22:41:50 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com> 📎                                              2016-12-17 22:54:04 from Bruce Momjian <bruce(at)momjian(dot)us>                                               2016-12-17 23:00:01 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                               2016-12-17 23:30:08 from David Fetter <david(at)fetter(dot)org>                                                2016-12-17 23:47:34 from Andres Freund <andres(at)anarazel(dot)de>                                                 2016-12-18 00:38:46 from Bruce Momjian <bruce(at)momjian(dot)us>                                                  2016-12-18 00:40:22 from Bruce Momjian <bruce(at)momjian(dot)us>                                            2016-12-21 12:56:10 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                             2016-12-21 13:37:07 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                              2016-12-21 22:35:25 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                               2016-12-27 01:33:44 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                2016-12-27 03:59:00 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                                 2016-12-27 04:31:28 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                  2017-01-23 11:26:41 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru> 📎                                                   2017-01-23 12:00:59 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com> 📎                                                    2017-01-24 06:42:57 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                     2017-01-24 11:08:07 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                     2017-01-24 13:01:30 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                                      2017-01-24 14:26:31 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                       2017-01-25 14:55:31 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                        2017-01-26 02:12:45 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                         2017-01-26 04:38:03 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                          2017-01-26 05:35:45 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                           2017-01-26 07:09:14 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                            2017-01-26 07:34:19 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                             2017-01-26 08:00:12 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>                                                             2017-01-26 08:02:48 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                              2017-01-26 23:53:52 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                               2017-01-27 09:59:07 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                2017-01-27 10:07:46 from Simon Riggs <simon(at)2ndquadrant(dot)com>                                                                 2017-01-27 11:01:38 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                  2017-01-27 11:23:31 from Simon Riggs <simon(at)2ndquadrant(dot)com>                                                                   2017-01-27 12:28:26 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                    2017-01-27 13:02:07 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                           2017-01-30 18:45:33 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                            2017-01-31 03:10:06 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                             2017-01-31 05:34:26 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                              2017-01-31 05:38:15 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                               2017-01-31 05:58:20 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                2017-01-31 06:06:44 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                 2017-02-02 06:07:20 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com> 📎                                                                  2017-02-21 22:03:10 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                   2017-02-22 02:07:19 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                  2017-02-23 07:20:34 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                   2017-02-27 05:19:54 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                    2017-03-02 15:25:40 from David Steele <david(at)pgmasters(dot)net>                                                                     2017-03-11 10:26:25 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com> 📎                                                                      2017-03-13 06:44:53 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                       2017-03-15 07:48:29 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com> 📎                                                                        2017-03-16 01:22:15 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                         2017-03-16 10:18:18 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                          2017-03-16 12:25:55 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                           2017-03-17 05:14:50 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                            2017-03-17 07:39:16 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                           2017-03-17 07:42:44 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                            2017-03-17 07:51:29 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                             2017-03-17 08:00:01 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                              2017-03-17 08:15:19 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                               2017-03-22 02:10:59 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com> 📎                                                                                2017-03-26 07:50:47 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                                 2017-03-27 00:05:14 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                                  2017-03-28 05:10:05 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com> 📎                                                                                   2017-03-28 05:31:55 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                                   2017-03-28 06:03:40 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                                    2017-03-28 06:08:25 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com>                                                                                     2017-03-28 06:10:52 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                                                      2017-04-05 00:22:34 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                    2017-01-31 17:25:47 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                     2017-02-01 08:29:25 from Nikhil Sontakke <nikhils(at)2ndquadrant(dot)com> 📎                                                      2017-02-03 22:17:41 from Robert Haas <robertmhaas(at)gmail(dot)com>                                 2016-09-06 09:09:37 from Simon Riggs <simon(at)2ndquadrant(dot)com>                       2016-04-08 13:36:19 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                        2016-04-08 13:45:12 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>             2016-04-08 18:42:28 from Robert Haas <robertmhaas(at)gmail(dot)com>              2016-04-08 18:55:15 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>              2016-04-08 18:57:59 from Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>     2016-01-09 18:27:13 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
2pc_xlog.diff	application/octet-stream	15.5 KB
unknown_filename	text/plain	843 bytes

In response to

• Re: Speedup twophase transactions at 2016-01-08 16:29:32 from Alvaro Herrera

Responses

• Re: Speedup twophase transactions at 2016-01-09 15:29:11 from Simon Riggs
• Re: Speedup twophase transactions at 2016-01-09 18:27:13 from Simon Riggs

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Kapila	2016-01-09 12:34:39	Re: checkpointer continuous flushing
Previous Message	Andres Freund	2016-01-09 12:23:55	Re: pgsql: Avoid pin scan for replay of XLOG_BTREE_VACUUM