Re: Improve WALRead() to suck data directly from WAL buffers when possible

From:	Michael Paquier <michael(at)paquier(dot)xyz>
To:	Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
Cc:	"Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>, Jeff Davis <pgsql(at)j-davis(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Subject:	Re: Improve WALRead() to suck data directly from WAL buffers when possible
Date:	2024-04-24 23:36:15
Message-ID:	ZimXbzeJrqY25Cmc@paquier.xyz
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-12-09 09:03:39 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎  2022-12-12 02:57:17 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>   2022-12-12 03:06:36 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>    2022-12-12 03:08:51 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>   2022-12-23 10:15:55 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>    2022-12-25 11:25:26 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>     2022-12-26 08:50:07 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎      2023-01-14 08:48:52 from Jeff Davis <pgsql(at)j-davis(dot)com>       2023-01-14 20:34:03 from Andres Freund <andres(at)anarazel(dot)de>        2023-01-25 20:27:30 from SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>        2023-01-25 21:15:40 from Andres Freund <andres(at)anarazel(dot)de>         2023-01-26 05:33:28 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎          2023-01-27 05:24:51 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>           2023-01-27 06:17:45 from Andres Freund <andres(at)anarazel(dot)de>            2023-01-27 06:46:04 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>             2023-01-27 09:35:01 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎        2023-10-03 23:05:32 from Jeff Davis <pgsql(at)j-davis(dot)com>         2023-10-11 22:43:53 from Andres Freund <andres(at)anarazel(dot)de>          2023-10-17 20:02:54 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>          2023-10-20 16:49:32 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎           2023-10-21 18:29:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎            2023-10-25 00:15:19 from Jeff Davis <pgsql(at)j-davis(dot)com>             2023-10-25 01:54:01 from Nathan Bossart <nathandbossart(at)gmail(dot)com>             2023-10-26 22:16:32 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎              2023-10-27 20:52:56 from Jeff Davis <pgsql(at)j-davis(dot)com>               2023-11-02 17:08:38 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                2023-11-03 07:05:06 from Jeff Davis <pgsql(at)j-davis(dot)com>                 2023-11-03 14:53:30 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                  2023-11-03 19:47:24 from Jeff Davis <pgsql(at)j-davis(dot)com>                   2023-11-04 15:25:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                    2023-11-04 21:27:39 from Jeff Davis <pgsql(at)j-davis(dot)com>                     2023-11-04 22:45:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                  2023-11-03 23:58:18 from Andres Freund <andres(at)anarazel(dot)de>                2023-11-04 00:43:48 from Andres Freund <andres(at)anarazel(dot)de>                 2023-11-08 07:40:34 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                  2023-11-09 20:58:36 from Andres Freund <andres(at)anarazel(dot)de>                   2023-11-13 13:32:07 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                    2023-12-07 10:29:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                     2023-12-08 00:34:57 from Jeff Davis <pgsql(at)j-davis(dot)com>                      2023-12-20 10:06:06 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                       2024-01-05 01:50:05 from Jeff Davis <pgsql(at)j-davis(dot)com>                        2024-01-10 14:29:29 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                         2024-01-20 01:47:57 from Jeff Davis <pgsql(at)j-davis(dot)com>                         2024-01-22 14:03:28 from Melih Mutlu <m(dot)melihmutlu(at)gmail(dot)com>                         2024-01-22 20:12:18 from Andres Freund <andres(at)anarazel(dot)de>                          2024-01-23 04:07:03 from Jeff Davis <pgsql(at)j-davis(dot)com> 📎                           2024-01-25 09:05:30 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                            2024-01-26 03:01:52 from Jeff Davis <pgsql(at)j-davis(dot)com>                             2024-01-26 14:01:24 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                              2024-01-26 19:34:26 from Jeff Davis <pgsql(at)j-davis(dot)com>                               2024-01-27 08:00:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                2024-01-30 17:31:41 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                 2024-01-31 09:00:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                  2024-01-31 09:31:29 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                   2024-01-31 11:36:40 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                  2024-02-12 19:33:24 from Jeff Davis <pgsql(at)j-davis(dot)com>                                   2024-02-12 20:18:53 from Andres Freund <andres(at)anarazel(dot)de>                                    2024-02-12 20:46:00 from Jeff Davis <pgsql(at)j-davis(dot)com>                                     2024-02-12 23:36:48 from Andres Freund <andres(at)anarazel(dot)de>                                      2024-02-13 01:33:24 from Jeff Davis <pgsql(at)j-davis(dot)com>                                       2024-02-14 01:29:47 from Jeff Davis <pgsql(at)j-davis(dot)com> 📎                                        2024-02-16 07:38:45 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                         2024-02-16 17:31:18 from Jeff Davis <pgsql(at)j-davis(dot)com>                                          2024-02-17 04:57:20 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                           2024-02-20 06:10:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                            2024-03-21 18:03:12 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                             2024-04-08 05:17:46 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                                              2024-04-09 06:33:49 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                                               2024-04-11 01:01:23 from Michael Paquier <michael(at)paquier(dot)xyz>                                                2024-04-24 16:16:20 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                                 2024-04-24 23:36:15 from Michael Paquier <michael(at)paquier(dot)xyz>                                       2024-02-14 02:55:08 from Andres Freund <andres(at)anarazel(dot)de>                                      2024-02-13 17:17:06 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                                       2024-02-14 01:32:30 from Jeff Davis <pgsql(at)j-davis(dot)com>                                   2024-02-12 23:56:19 from Jeff Davis <pgsql(at)j-davis(dot)com>                                    2024-02-13 00:11:50 from Andres Freund <andres(at)anarazel(dot)de>                                   2024-02-13 09:30:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>      2023-02-07 10:42:37 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>       2023-02-08 04:27:27 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎        2023-02-08 05:03:38 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>         2023-02-08 14:30:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎          2023-02-28 00:44:52 from Nathan Bossart <nathandbossart(at)gmail(dot)com>           2023-02-28 05:08:31 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>            2023-02-28 18:36:11 from Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>             2023-03-01 09:09:54 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎              2023-03-02 11:43:32 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎            2023-03-01 04:15:23 from Nathan Bossart <nathandbossart(at)gmail(dot)com>             2023-03-03 13:30:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎              2023-03-06 22:00:27 from Nathan Bossart <nathandbossart(at)gmail(dot)com>               2023-03-07 07:09:13 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                2023-03-07 17:44:50 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                 2023-03-14 07:58:42 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎                2023-03-11 19:22:00 from Nitin Jadhav <nitinjadhavpostgres(at)gmail(dot)com> 📎                 2023-03-12 17:30:00 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>                  2023-03-14 03:32:23 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> 📎
Lists:	pgsql-hackers

In response to

• Re: Improve WALRead() to suck data directly from WAL buffers when possible at 2024-04-24 16:16:20 from Bharath Rupireddy

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	David G. Johnston	2024-04-24 23:43:58	Re: Partitioned tables and [un]loggedness
Previous Message	Michael Paquier	2024-04-24 23:35:32	Re: Partitioned tables and [un]loggedness