Re: POC: postgres_fdw insert batching

From:	Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
To:	Amit Langote <amitlangote09(at)gmail(dot)com>
Cc:	"tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>, "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: POC: postgres_fdw insert batching
Date:	2021-01-20 23:00:34
Message-ID:	7e70a11e-cf5d-2e5f-a802-274c5e0e236b@enterprisedb.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2020-06-28 15:10:02 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎  2020-06-29 05:00:28 from Amit Langote <amitlangote09(at)gmail(dot)com>  2020-06-29 10:52:15 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>   2020-06-30 03:18:03 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>    2020-06-30 04:22:44 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>     2020-06-30 05:53:55 from Amit Langote <amitlangote09(at)gmail(dot)com>      2020-06-30 08:10:23 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>   2020-06-30 16:53:37 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>    2020-07-01 04:47:00 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>  2020-07-01 18:34:33 from Andres Freund <andres(at)anarazel(dot)de>  2020-07-10 04:28:44 from "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru>   2020-07-12 00:11:01 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>    2020-10-01 04:12:54 from Michael Paquier <michael(at)paquier(dot)xyz>    2020-10-08 02:40:10 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>     2020-10-08 22:14:21 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>      2020-10-09 03:01:53 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>       2020-11-10 00:45:50 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> 📎        2020-11-10 15:05:14 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>         2020-11-10 17:16:38 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>         2020-11-11 07:20:15 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>          2020-11-11 16:04:37 from Tim(dot)Colles(at)ed(dot)ac(dot)uk           2020-11-12 02:06:49 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>          2020-11-17 09:11:55 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> 📎           2020-11-18 18:57:30 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎            2020-11-19 02:43:07 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>             2020-11-19 14:04:59 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>              2020-11-23 02:17:14 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> 📎               2020-11-24 01:44:45 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                2020-11-24 08:45:40 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                 2020-11-24 17:08:57 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                  2020-11-25 05:04:36 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> 📎                   2020-11-30 08:29:02 from David Fetter <david(at)fetter(dot)org>                    2020-11-30 09:34:57 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                   2021-01-12 02:06:29 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                    2021-01-12 03:04:54 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                    2021-01-13 09:15:05 from Amit Langote <amitlangote09(at)gmail(dot)com>                     2021-01-13 14:43:29 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                      2021-01-13 17:41:09 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                       2021-01-14 01:14:45 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                       2021-01-14 08:58:53 from Amit Langote <amitlangote09(at)gmail(dot)com>                        2021-01-14 12:57:44 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                         2021-01-14 13:57:10 from Amit Langote <amitlangote09(at)gmail(dot)com>                          2021-01-14 15:05:25 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                           2021-01-15 02:47:12 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                           2021-01-15 13:48:49 from Amit Langote <amitlangote09(at)gmail(dot)com>                            2021-01-15 14:59:55 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                             2021-01-15 15:34:09 from Amit Langote <amitlangote09(at)gmail(dot)com>                              2021-01-18 06:51:45 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> 📎                               2021-01-18 15:27:54 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                2021-01-19 01:56:50 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                               2021-01-18 17:56:23 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                2021-01-19 01:28:44 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                 2021-01-19 02:35:42 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                  2021-01-19 03:50:03 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> 📎                                   2021-01-19 04:51:53 from Amit Langote <amitlangote09(at)gmail(dot)com>                                    2021-01-19 05:06:34 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                     2021-01-19 06:23:51 from Amit Langote <amitlangote09(at)gmail(dot)com>                                      2021-01-19 16:01:05 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                       2021-01-20 02:05:32 from Amit Langote <amitlangote09(at)gmail(dot)com>                                        2021-01-20 23:00:34 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                         2021-01-20 23:52:25 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                          2021-01-21 00:17:39 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                           2021-01-21 00:56:25 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                            2021-01-21 01:02:56 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                             2021-01-21 01:11:32 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                              2021-01-21 01:16:43 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                               2021-01-21 01:37:35 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                                2021-01-21 01:49:00 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                 2021-01-21 01:57:29 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                            2021-01-21 01:24:55 from Amit Langote <amitlangote09(at)gmail(dot)com>                                             2021-01-21 01:42:03 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                              2021-01-21 01:52:48 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                               2021-01-21 02:03:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                2021-01-21 02:22:34 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                              2021-01-21 01:53:14 from Amit Langote <amitlangote09(at)gmail(dot)com>                                               2021-01-21 02:00:42 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                                2021-01-21 02:09:17 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                                 2021-01-21 02:36:31 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                  2021-01-23 08:31:18 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                   2021-01-23 14:58:33 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                   2021-01-23 17:16:54 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                    2021-01-24 12:31:42 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                     2021-01-25 04:21:39 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                                      2021-02-05 02:52:00 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                       2021-02-05 04:11:52 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>                                                       2021-02-15 16:36:00 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                        2021-02-16 09:25:25 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                         2021-02-16 15:04:44 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                          2021-02-17 08:51:12 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                           2021-02-17 19:36:36 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                            2021-02-17 23:38:08 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                                             2021-02-18 04:51:31 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                            2021-02-18 07:35:20 from Amit Langote <amitlangote09(at)gmail(dot)com>                                          2021-01-21 00:21:29 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                                           2021-01-21 01:22:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                            2021-01-21 01:45:12 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                         2021-01-20 23:59:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                          2021-01-21 00:46:29 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                                         2021-01-22 05:50:49 from Ian Lawrence Barwick <barwick(at)gmail(dot)com> 📎                                          2021-02-05 01:54:15 from Ian Lawrence Barwick <barwick(at)gmail(dot)com>                                          2021-02-05 01:55:04 from Ian Lawrence Barwick <barwick(at)gmail(dot)com>                                           2021-02-15 16:32:43 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>     2020-11-25 02:10:44 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>      2020-11-25 06:31:53 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>       2020-11-25 20:04:51 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>        2020-11-26 01:48:08 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>         2020-11-26 19:34:04 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>          2020-11-27 01:46:38 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>          2020-11-27 02:47:51 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>           2020-11-27 03:56:15 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>            2020-11-27 06:05:55 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>             2020-11-28 02:10:40 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>              2020-11-28 07:00:31 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>             2020-11-30 02:34:00 from Craig Ringer <craig(dot)ringer(at)enterprisedb(dot)com>              2020-11-30 09:13:58 from "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>
Lists:	pgsql-hackers

In response to

• Re: POC: postgres_fdw insert batching at 2021-01-20 02:05:32 from Amit Langote

Responses

• Re: POC: postgres_fdw insert batching at 2021-01-20 23:52:25 from Tomas Vondra
• Re: POC: postgres_fdw insert batching at 2021-01-20 23:59:42 from Tom Lane
• Re: POC: postgres_fdw insert batching at 2021-01-22 05:50:49 from Ian Lawrence Barwick

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Tom Lane	2021-01-20 23:07:58	Re: [PATCH 1/1] Fix detection of pwritev support for OSX.
Previous Message	Heikki Linnakangas	2021-01-20 22:11:37	Re: ResourceOwner refactoring