| From: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Fdw batch insert error out when set batch_size > 65535 |
| Date: | 2021-06-09 14:05:49 |
| Message-ID: | 6abb33e8-db04-3d39-4f9a-7a22a75e0cc8@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 6/9/21 3:28 PM, Tom Lane wrote:
> Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> writes:
>> Note that the problem here is [1] - we're creating a lot of slots
>> referencing the same tuple descriptor, which inflates the duration.
>> There's a fix in the other thread, which eliminates ~99% of the
>> overhead. I plan to push that fix soon (a day or two).
>
> Oh, okay, as long as there's a plan to bring the time back down.
>
Yeah. Sorry for not mentioning this in the original message about the
new regression test.
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Christensen | 2021-06-09 14:32:36 | Re: DELETE CASCADE |
| Previous Message | Fujii Masao | 2021-06-09 14:04:22 | Re: RFC: Logging plan of the running query |