Re: WIP: WAL prefetch (another approach)

From:	Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc:	Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Andres Freund <andres(at)anarazel(dot)de>, Jakub Wartak <Jakub(dot)Wartak(at)tomtom(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, David Steele <david(at)pgmasters(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: WIP: WAL prefetch (another approach)
Date:	2021-04-09 20:45:50
Message-ID:	CA+hUKGKWPP=zXNnbZ3gfSQXF=ih00nxgrWU-qFC7qWgTredc2g@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2020-01-01 13:39:04 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎  2020-01-02 18:10:55 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>   2020-01-03 04:57:44 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>    2020-02-12 06:52:42 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎     2020-03-02 05:43:23 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎      2020-03-13 21:15:09 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>       2020-03-17 06:32:55 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎        2020-03-18 01:47:54 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>         2020-03-18 05:18:44 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎          2020-03-24 22:31:52 from Andres Freund <andres(at)anarazel(dot)de>           2020-04-07 16:24:21 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎            2020-04-08 00:52:27 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>             2020-04-08 11:27:56 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎              2020-04-08 12:12:13 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>               2020-04-08 12:27:39 from David Steele <david(at)pgmasters(dot)net>                2020-04-08 21:55:25 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                 2020-04-19 11:48:20 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                  2020-04-21 05:26:52 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                   2020-04-25 19:19:35 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                    2020-05-02 15:14:23 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                     2020-05-28 11:12:29 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                      2020-05-28 21:14:25 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                      2020-06-05 15:20:52 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                       2020-06-05 20:04:14 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                        2020-06-05 20:40:57 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                         2020-06-05 21:15:14 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                      2020-06-05 22:34:22 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                       2020-06-06 00:36:32 from Stephen Frost <sfrost(at)snowman(dot)net>                        2020-07-02 03:09:29 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                         2020-08-03 15:46:59 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                          2020-08-06 02:58:44 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                           2020-08-06 10:47:01 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                            2020-08-13 06:57:20 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                             2020-08-26 13:13:41 from Sait Talha Nisanci <Sait(dot)Nisanci(at)microsoft(dot)com>                              2020-08-27 13:51:56 from Robert Haas <robertmhaas(at)gmail(dot)com>                              2020-08-27 13:55:33 from Stephen Frost <sfrost(at)snowman(dot)net>                               2020-08-27 17:36:01 from Sait Talha Nisanci <Sait(dot)Nisanci(at)microsoft(dot)com>                                2020-08-27 18:26:42 from Stephen Frost <sfrost(at)snowman(dot)net>                                 2020-08-27 18:40:28 from Andres Freund <andres(at)anarazel(dot)de>                                  2020-08-27 18:51:16 from Stephen Frost <sfrost(at)snowman(dot)net>                                   2020-08-27 20:19:23 from Robert Haas <robertmhaas(at)gmail(dot)com>                                    2020-08-27 20:28:54 from Stephen Frost <sfrost(at)snowman(dot)net>                                     2020-08-29 22:14:50 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                      2020-08-30 12:24:01 from Stephen Frost <sfrost(at)snowman(dot)net>                                       2020-09-01 06:14:52 from Sait Talha Nisanci <Sait(dot)Nisanci(at)microsoft(dot)com>                             2020-09-01 13:14:26 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                              2020-09-01 14:05:10 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                               2020-09-01 14:18:26 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                2020-09-05 00:05:52 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                 2020-09-08 23:16:27 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                  2020-09-23 23:38:45 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                   2020-10-06 05:04:57 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                    2020-10-10 11:29:35 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                                     2020-11-13 02:20:26 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                      2020-11-13 10:45:51 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                       2020-11-13 15:13:45 from Stephen Frost <sfrost(at)snowman(dot)net>                                        2020-11-18 05:10:31 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                         2020-11-18 21:00:39 from Stephen Frost <sfrost(at)snowman(dot)net>                                          2020-11-25 03:57:47 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                           2020-12-04 18:27:38 from Stephen Frost <sfrost(at)snowman(dot)net>                                            2020-12-04 18:51:57 from Andres Freund <andres(at)anarazel(dot)de>                                             2020-12-04 19:01:45 from Stephen Frost <sfrost(at)snowman(dot)net>                                            2021-01-27 04:34:22 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                         2020-12-11 12:24:29 from Jakub Wartak <Jakub(dot)Wartak(at)tomtom(dot)com> 📎                                          2020-12-24 03:06:38 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                           2020-12-30 03:57:36 from Andres Freund <andres(at)anarazel(dot)de>                                           2021-02-04 00:40:26 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                            2021-02-10 08:26:49 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                           2021-02-10 21:50:33 from Stephen Frost <sfrost(at)snowman(dot)net>                                            2021-02-11 23:42:04 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                             2021-02-12 04:46:14 from Andres Freund <andres(at)anarazel(dot)de>                                              2021-02-12 17:53:03 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                              2021-02-13 21:39:30 from Stephen Frost <sfrost(at)snowman(dot)net>                                               2021-02-14 22:38:01 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                2021-02-14 23:18:15 from Stephen Frost <sfrost(at)snowman(dot)net>                                                 2021-03-17 16:12:17 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                  2021-03-17 21:43:31 from Stephen Frost <sfrost(at)snowman(dot)net>                                                   2021-03-17 23:00:04 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                    2021-03-18 00:54:18 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                     2021-03-19 01:29:04 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                      2021-04-01 21:50:31 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                       2021-04-07 11:24:25 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                        2021-04-07 15:27:43 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                         2021-04-08 11:46:21 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                          2021-04-08 12:39:18 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                          2021-04-21 16:30:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                           2021-04-21 20:07:43 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                            2021-04-21 20:16:43 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                             2021-04-21 23:16:17 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                              2021-04-21 23:22:33 from Stephen Frost <sfrost(at)snowman(dot)net>                                                               2021-04-22 01:21:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                2021-04-22 01:34:11 from Andres Freund <andres(at)anarazel(dot)de>                                                                 2021-04-22 02:15:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                2021-04-22 01:59:58 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                 2021-04-28 16:32:45 from Andres Freund <andres(at)anarazel(dot)de>                                                                  2021-04-28 16:45:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                   2021-04-28 22:46:14 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                    2021-04-28 23:24:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                     2021-04-29 00:12:24 from Andres Freund <andres(at)anarazel(dot)de>                                                                      2021-04-29 00:24:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                       2021-04-29 00:59:22 from Andres Freund <andres(at)anarazel(dot)de>                                                                        2021-04-29 02:25:53 from Andres Freund <andres(at)anarazel(dot)de> 📎                                                                        2021-04-29 03:14:09 from Andres Freund <andres(at)anarazel(dot)de>                                                                         2021-04-29 03:39:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                         2021-04-29 04:27:36 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                       2021-05-03 01:23:25 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                    2021-05-02 03:16:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                     2021-05-03 05:42:35 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                      2021-05-04 12:37:22 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                                       2021-05-04 13:46:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                        2021-05-04 19:47:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                         2021-05-05 01:08:35 from Andres Freund <andres(at)anarazel(dot)de>                                                                          2021-05-06 20:23:43 from Andres Freund <andres(at)anarazel(dot)de>                                                                        2021-05-06 09:50:38 from Andres Freund <andres(at)anarazel(dot)de>                                                               2021-05-10 04:11:08 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                2021-11-15 10:31:42 from Daniel Gustafsson <daniel(at)yesql(dot)se>                                                                 2021-11-23 10:13:57 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                                  2021-11-25 22:32:07 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                                                   2021-11-26 21:16:33 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                    2021-11-26 23:34:21 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                                     2021-11-27 01:47:01 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                      2021-11-27 02:46:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                       2021-12-13 14:23:42 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                       2021-12-17 02:36:37 from Greg Stark <stark(at)mit(dot)edu>                                                                        2021-12-17 03:09:58 from Greg Stark <stark(at)mit(dot)edu>                                                                        2021-12-17 04:11:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                         2021-12-17 18:27:50 from Greg Stark <stark(at)mit(dot)edu>                                                                          2021-12-17 18:59:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                           2021-12-17 19:40:20 from Greg Stark <stark(at)mit(dot)edu>                                                                            2021-12-17 19:53:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                             2021-12-17 22:56:22 from Greg Stark <stark(at)mit(dot)edu>                                                                              2021-12-17 23:04:00 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                                              2021-12-17 23:40:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                               2021-12-17 23:55:50 from Greg Stark <stark(at)mit(dot)edu>                                                                                2021-12-18 00:38:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                  2021-12-10 08:39:57 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                                                   2021-12-29 04:29:52 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                                    2021-12-29 05:27:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                    2021-12-29 19:41:42 from Andres Freund <andres(at)anarazel(dot)de>                                                                    2022-03-08 05:15:43 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                                     2022-03-08 13:48:54 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                                     2022-03-08 21:17:16 from Andres Freund <andres(at)anarazel(dot)de>                                                                     2022-03-09 06:46:33 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                      2022-03-11 05:31:13 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                                       2022-03-11 05:35:26 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                                       2022-03-11 06:03:18 from Andres Freund <andres(at)anarazel(dot)de>                                                                       2022-03-11 08:27:37 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                        2022-03-14 05:15:59 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                                         2022-03-14 07:17:13 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                          2022-03-17 20:59:31 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                           2022-03-20 04:36:38 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                                            2022-03-20 07:52:04 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                            2022-03-21 08:29:16 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                             2022-03-31 09:49:32 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com> 📎                                                                              2022-04-04 03:12:31 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                               2022-04-07 07:45:23 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                2022-04-12 13:58:17 from Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>                                                                                 2022-04-12 15:41:00 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                                                  2022-04-12 15:46:39 from Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>                                                                                   2022-04-12 16:07:20 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                                                   2022-04-12 18:04:41 from SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>                                                                                 2022-04-12 15:57:41 from Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org>                                                                                  2022-04-12 20:05:11 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                   2022-04-25 18:11:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                    2022-04-25 18:31:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                     2022-04-26 06:11:20 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                      2022-04-27 00:10:40 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                                   2022-09-25 02:31:37 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                        2021-04-09 03:37:04 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                         2021-04-09 20:27:42 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                          2021-04-09 20:36:58 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                           2021-04-09 20:45:50 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                            2021-04-13 02:33:12 from "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi(dot)shinoda(at)hpe(dot)com> 📎                                                            2021-04-16 12:05:42 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                         2022-04-07 12:55:55 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                          2022-04-08 01:46:49 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                           2022-04-12 09:01:51 from "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi(dot)shinoda(at)hpe(dot)com> 📎                                                            2022-04-12 09:28:26 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                             2022-04-12 09:32:16 from "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi(dot)shinoda(at)hpe(dot)com>                                   2020-10-07 00:58:38 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Lists:	pgsql-hackers

In response to

• Re: WIP: WAL prefetch (another approach) at 2021-04-09 20:36:58 from Justin Pryzby

Responses

• RE: WIP: WAL prefetch (another approach) at 2021-04-13 02:33:12 from Shinoda, Noriyoshi (PN Japan FSIP)
• Re: WIP: WAL prefetch (another approach) at 2021-04-16 12:05:42 from Amit Kapila

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Robert Haas	2021-04-09 20:51:53	Re: pg_amcheck contrib application
Previous Message	Thomas Munro	2021-04-09 20:44:17	Re: Another small guc.c fix