RE: Disable WAL logging to speed up data loading

From:	"osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>
To:	"osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>, "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>, 'Kyotaro Horiguchi' <horikyota(dot)ntt(at)gmail(dot)com>
Cc:	"sawada(dot)mshk(at)gmail(dot)com" <sawada(dot)mshk(at)gmail(dot)com>, "masao(dot)fujii(at)oss(dot)nttdata(dot)com" <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, "laurenz(dot)albe(at)cybertec(dot)at" <laurenz(dot)albe(at)cybertec(dot)at>, "ashutosh(dot)bapat(dot)oss(at)gmail(dot)com" <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	RE: Disable WAL logging to speed up data loading
Date:	2020-12-03 03:14:52
Message-ID:	OSBPR01MB48883A7BAB3DB9009D755FFBEDF20@OSBPR01MB4888.jpnprd01.prod.outlook.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2020-09-29 08:28:03 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>  2020-09-29 09:40:24 from Amul Sul <sulamul(at)gmail(dot)com>   2020-09-30 02:33:21 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>  2020-09-29 12:40:42 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>   2020-09-30 03:10:53 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>    2020-10-01 01:01:56 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>     2020-10-01 02:51:36 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>     2020-10-01 03:04:38 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>      2020-10-01 03:58:19 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>       2020-10-01 04:38:41 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>        2020-10-01 08:14:42 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>         2020-10-02 01:06:21 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎          2020-10-02 01:56:21 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>           2020-10-02 04:38:22 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>            2020-10-02 04:51:35 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>             2020-10-02 05:07:52 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>           2020-10-02 05:03:37 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>            2020-10-28 04:11:28 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> 📎             2020-10-28 07:18:08 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>              2020-10-28 09:55:45 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>               2020-10-28 13:05:05 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                2020-10-28 20:32:07 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                 2020-10-29 00:07:51 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                  2020-10-29 10:24:21 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                2020-10-29 02:42:18 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>                 2020-10-29 10:21:40 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                  2020-10-29 20:00:39 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>                   2020-10-30 04:32:03 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                    2020-11-02 00:27:14 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                   2020-10-30 12:28:30 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                   2020-11-02 15:28:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2020-11-02 15:35:23 from Magnus Hagander <magnus(at)hagander(dot)net>                     2020-11-02 18:01:59 from Stephen Frost <sfrost(at)snowman(dot)net>                      2020-11-09 06:30:55 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                       2020-11-09 15:18:08 from Stephen Frost <sfrost(at)snowman(dot)net>                        2020-11-09 17:05:21 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                         2020-11-09 17:36:20 from Stephen Frost <sfrost(at)snowman(dot)net>                          2020-11-09 18:20:40 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                           2020-11-09 19:26:41 from Stephen Frost <sfrost(at)snowman(dot)net>                         2020-11-17 02:49:17 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                        2020-11-10 00:59:41 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                         2020-11-10 14:16:28 from Stephen Frost <sfrost(at)snowman(dot)net>                         2020-11-11 03:07:01 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                      2020-11-19 02:07:54 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                       2020-11-19 03:45:24 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                        2020-11-19 05:24:57 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                         2020-11-19 07:50:24 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                          2020-11-19 10:26:12 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                          2020-11-19 16:04:17 from Stephen Frost <sfrost(at)snowman(dot)net>                           2020-11-20 00:22:05 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                            2020-11-20 00:32:38 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                             2020-11-20 01:19:05 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                              2020-11-20 16:03:49 from Stephen Frost <sfrost(at)snowman(dot)net>                    2020-11-17 01:45:53 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                 2020-11-16 07:19:52 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> 📎                  2020-11-19 07:50:46 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                   2020-11-20 12:47:25 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> 📎                    2020-11-23 03:17:29 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                     2020-11-24 02:18:51 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> 📎                      2020-11-27 06:07:34 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                       2020-11-27 06:38:43 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                       2020-11-27 07:01:16 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                        2020-11-27 08:35:24 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                         2020-11-27 13:34:49 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                          2020-11-30 05:07:20 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                           2020-11-30 06:45:15 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                           2020-12-01 01:42:29 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                            2020-12-01 13:59:33 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                             2020-12-02 02:21:52 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                             2020-12-03 03:14:52 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> 📎                              2020-12-03 03:52:47 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                               2020-12-25 07:09:06 from Michael Paquier <michael(at)paquier(dot)xyz>                                2020-12-25 11:27:12 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                2020-12-28 11:06:30 from Simon Riggs <simon(at)2ndquadrant(dot)com>                                 2020-12-30 13:04:41 from Michael Paquier <michael(at)paquier(dot)xyz>                                  2020-12-30 13:53:45 from Simon Riggs <simon(at)2ndquadrant(dot)com>                                  2021-01-01 03:27:31 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                 2021-01-01 03:51:26 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                               2021-01-07 15:46:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                                2021-01-08 05:12:02 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                 2021-01-08 06:10:55 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                 2021-01-08 10:50:13 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                  2021-01-11 00:14:04 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                   2021-01-12 03:13:53 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> 📎                                    2021-01-12 03:51:44 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                     2021-01-12 07:09:28 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> 📎                                      2021-01-12 07:22:49 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                      2021-01-13 02:07:06 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                       2021-01-13 03:46:17 from movead li <lchch1990(at)sina(dot)cn>                                        2021-01-15 14:27:03 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                       2021-01-13 06:01:34 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                        2021-01-13 08:12:55 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                         2021-01-14 00:27:16 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                          2021-01-15 14:18:26 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> 📎                                           2021-01-17 05:16:09 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                            2021-03-18 16:50:11 from David Steele <david(at)pgmasters(dot)net>                                             2021-03-19 06:53:29 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                              2021-03-19 07:45:02 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                                               2021-03-19 08:29:43 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                              2021-03-19 15:13:52 from Stephen Frost <sfrost(at)snowman(dot)net>                                               2021-03-22 04:18:41 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                                2021-03-22 13:46:04 from Stephen Frost <sfrost(at)snowman(dot)net>                                                 2021-03-22 14:59:04 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                                                  2021-03-22 15:05:43 from Stephen Frost <sfrost(at)snowman(dot)net>                                                   2021-03-22 17:09:23 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                                                    2021-03-22 17:22:49 from Stephen Frost <sfrost(at)snowman(dot)net>                                                     2021-03-23 03:11:25 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                                      2021-03-23 18:05:38 from Stephen Frost <sfrost(at)snowman(dot)net>                                                       2021-03-24 08:15:44 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                                        2021-03-24 11:43:57 from Stephen Frost <sfrost(at)snowman(dot)net>                                                         2021-04-07 06:43:19 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com> 📎                                                          2021-07-04 03:00:57 from vignesh C <vignesh21(at)gmail(dot)com>                                                           2021-07-04 15:02:01 from Stephen Frost <sfrost(at)snowman(dot)net>                                                            2021-07-05 01:31:54 from Michael Paquier <michael(at)paquier(dot)xyz>                                                             2021-07-05 02:35:49 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                                              2021-07-05 13:57:41 from Stephen Frost <sfrost(at)snowman(dot)net>                                                     2021-03-23 03:33:20 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                              2020-12-28 05:28:48 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                               2020-12-28 07:29:40 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                2020-12-28 10:11:53 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                 2021-01-05 01:54:08 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                  2021-01-05 08:45:24 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                   2021-01-06 08:09:16 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                        2020-11-27 09:33:46 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                       2020-11-27 09:23:11 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                    2020-11-23 03:18:51 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>             2020-10-28 08:46:02 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>          2020-11-10 14:33:12 from Stephen Frost <sfrost(at)snowman(dot)net>           2020-11-11 08:35:21 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>            2020-11-11 09:24:48 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>             2020-11-11 14:36:24 from Stephen Frost <sfrost(at)snowman(dot)net>              2020-11-12 02:46:08 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
disable_WAL_logging_v05.patch	application/octet-stream	15.0 KB

In response to

• RE: Disable WAL logging to speed up data loading at 2020-12-01 13:59:33 from osumi.takamichi@fujitsu.com

Responses

• RE: Disable WAL logging to speed up data loading at 2020-12-03 03:52:47 from tsunakawa.takay@fujitsu.com
• Re: Disable WAL logging to speed up data loading at 2020-12-28 05:28:48 from Masahiko Sawada

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Langote	2020-12-03 03:27:53	Re: Huge memory consumption on partitioned table with FKs
Previous Message	tsunakawa.takay@fujitsu.com	2020-12-03 02:48:13	RE: Deprecate custom encoding conversions