Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)

From:	Aleksander Alekseev <aleksander(at)timescale(dot)com>
To:	Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc:	Michael Paquier <michael(at)paquier(dot)xyz>, Ian Lawrence Barwick <barwick(at)gmail(dot)com>, Maxim Orlov <orlovmg(at)gmail(dot)com>, Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>, Hamid Akhtar <hamid(dot)akhtar(at)percona(dot)com>, Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Japin Li <japinli(at)hotmail(dot)com>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Ilya Anfimov <ilan(at)tzirechnoy(dot)com>
Subject:	Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)
Date:	2022-12-07 08:40:08
Message-ID:	CAJ7c6TNg77Q7sA7NGk=jUkAaE2yyvXKWRY3NNnL4yhmG_Lvpng@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-03-17 13:12:28 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎  2022-03-17 13:20:39 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>  2022-03-17 13:23:36 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>   2022-03-17 13:31:06 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>    2022-03-17 14:07:32 from Japin Li <japinli(at)hotmail(dot)com>     2022-03-17 14:41:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2022-03-17 14:46:30 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>      2022-03-17 16:25:00 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎       2022-03-18 01:20:08 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>        2022-03-18 01:23:44 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>        2022-03-18 02:29:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2022-03-18 13:50:01 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎        2022-03-18 14:10:39 from Aleksander Alekseev <aleksander(at)timescale(dot)com>         2022-03-18 14:39:21 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>          2022-03-18 15:14:52 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎           2022-03-18 23:20:49 from Andres Freund <andres(at)anarazel(dot)de>            2022-03-19 09:52:35 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>           2022-03-21 18:40:22 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>            2022-03-22 07:35:05 from Aleksander Alekseev <aleksander(at)timescale(dot)com>             2022-03-22 08:31:58 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>              2022-03-22 11:54:56 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎               2022-03-22 13:21:10 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                2022-03-22 17:22:59 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                 2022-03-23 00:24:26 from Japin Li <japinli(at)hotmail(dot)com>                  2022-03-23 09:51:33 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                   2022-03-23 22:33:20 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>                    2022-03-24 15:26:45 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                     2022-03-24 15:29:23 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                      2022-03-24 16:12:20 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                       2022-03-24 20:02:55 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                        2022-03-25 03:07:18 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                        2022-03-25 14:06:39 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                         2022-03-25 14:42:36 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                          2022-03-28 10:46:02 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                           2022-03-28 13:45:48 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>                            2022-03-29 13:09:14 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                             2022-03-29 17:25:49 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>                              2022-03-31 14:35:30 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                               2022-04-05 11:01:06 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                2022-04-13 10:54:02 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                 2022-04-26 12:55:16 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                  2022-05-13 13:21:29 from Maxim Orlov <orlovmg(at)gmail(dot)com>                                   2022-07-08 09:05:08 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                    2022-07-08 14:40:00 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                     2022-07-13 14:38:05 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                   2022-07-13 14:54:39 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                    2022-07-13 15:48:23 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                     2022-07-15 11:29:21 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                      2022-07-26 18:35:13 from Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>                                       2022-09-27 13:54:04 from Hamid Akhtar <hamid(dot)akhtar(at)percona(dot)com>                                        2022-09-27 14:25:14 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                         2022-10-06 10:05:39 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                         2022-10-06 10:45:20 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                          2022-10-06 12:15:37 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                           2022-10-07 11:00:50 from Maxim Orlov <orlovmg(at)gmail(dot)com>                                            2022-10-10 09:16:12 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                             2022-11-03 07:51:13 from Ian Lawrence Barwick <barwick(at)gmail(dot)com>                                              2022-11-03 08:15:43 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                               2022-11-03 08:20:11 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>                                               2022-11-03 09:29:44 from Ian Lawrence Barwick <barwick(at)gmail(dot)com>                                                2022-11-16 08:37:20 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                 2022-11-17 09:44:54 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                  2022-11-21 09:21:09 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                   2022-12-02 05:15:47 from Michael Paquier <michael(at)paquier(dot)xyz>                                                    2022-12-07 08:40:08 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                     2022-12-07 17:50:27 from Andres Freund <andres(at)anarazel(dot)de>                                                      2022-12-07 17:57:01 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                       2022-12-09 09:50:46 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                        2022-12-09 13:42:31 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                         2022-12-19 14:40:52 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                                          2023-01-06 05:30:49 from Andrey Borodin <amborodin86(at)gmail(dot)com>                                                           2023-01-09 13:29:01 from Maxim Orlov <orlovmg(at)gmail(dot)com>                                                           2023-01-09 13:30:47 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                          2023-01-06 06:51:23 from Japin Li <japinli(at)hotmail(dot)com>                                                           2023-01-09 14:03:27 from Maxim Orlov <orlovmg(at)gmail(dot)com>                                                            2023-01-09 14:15:21 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                                             2023-01-11 09:22:50 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                              2023-01-11 09:47:57 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                               2023-01-11 16:49:52 from Jacob Champion <jchampion(at)timescale(dot)com>                                                                2023-01-17 13:32:56 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                                 2023-02-20 15:30:31 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                                  2023-02-21 13:58:54 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                                   2023-02-22 14:29:29 from Maxim Orlov <orlovmg(at)gmail(dot)com>                                                                    2023-02-27 09:10:38 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                                     2023-02-28 14:17:10 from Maxim Orlov <orlovmg(at)gmail(dot)com>                                                                      2023-02-28 17:37:23 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                                       2023-03-01 10:21:21 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                                        2023-03-06 19:48:02 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                                         2023-03-07 11:38:50 from Maxim Orlov <orlovmg(at)gmail(dot)com>                                                                          2023-03-07 12:38:14 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                                           2023-03-07 13:18:13 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                                           2023-03-07 14:06:43 from Maxim Orlov <orlovmg(at)gmail(dot)com>                                                                            2023-03-09 15:21:38 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                                             2023-03-20 15:58:00 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                                                              2023-03-29 09:32:39 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                                             2023-07-05 12:26:04 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                                              2023-07-05 13:45:49 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                                               2023-09-04 14:41:43 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                                                2023-10-04 02:57:08 from Thomas wen <Thomas_valentine_365(at)outlook(dot)com>                                                                               2023-11-06 13:07:34 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                2023-11-06 13:42:38 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                                                                 2023-11-06 14:00:57 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                  2023-11-06 14:14:14 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                                                                   2023-11-06 14:28:23 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                                                2023-11-06 14:38:00 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                                                 2023-11-06 21:00:46 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                 2023-11-07 16:20:27 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                                                                  2023-11-09 16:22:11 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                                                                                   2023-11-26 23:43:26 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                    2023-11-27 07:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                                     2023-11-28 08:35:13 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                     2023-11-30 04:03:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                      2023-11-30 08:29:46 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                                                                                       2023-11-30 09:37:07 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                        2023-12-04 06:34:25 from John Naylor <johncnaylorls(at)gmail(dot)com>                                                                                         2023-12-04 08:12:18 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                                                                          2023-12-04 10:22:03 from John Naylor <johncnaylorls(at)gmail(dot)com>                                                                                           2023-12-04 14:02:06 from Thomas wen <Thomas_valentine_365(at)outlook(dot)com>                                                                                    2023-11-28 09:13:24 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                                                     2023-11-28 10:14:51 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                                                                      2023-11-28 10:37:08 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                                                       2023-11-28 10:38:54 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                                                                        2023-11-28 12:06:28 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                                                         2023-11-28 18:03:46 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                          2023-12-16 23:48:13 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                           2023-12-17 15:22:23 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                                     2023-12-17 21:14:03 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                2023-11-07 11:57:12 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                                                                                 2023-11-07 12:05:10 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                                                                                  2023-11-08 14:17:26 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                   2022-03-24 14:43:51 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v48-0001-Use-64-bit-numbering-of-SLRU-pages.patch	application/octet-stream	29.9 KB
v48-0002-Use-64-bit-format-to-output-XIDs.patch	application/octet-stream	126.3 KB
v48-0003-Use-64-bit-FullTransactionId-instead-of-Epoch-xi.patch	application/octet-stream	18.8 KB

In response to

• Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) at 2022-12-02 05:15:47 from Michael Paquier

Responses

• Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) at 2022-12-07 17:50:27 from Andres Freund

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Langote	2022-12-07 08:47:13	Re: ExecRTCheckPerms() and many prunable partitions
Previous Message	Anton A. Melnikov	2022-12-07 08:03:45	Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica.