Re: Fdw batch insert error out when set batch_size > 65535 - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: Fdw batch insert error out when set batch_size > 65535
Date
Msg-id 6abb33e8-db04-3d39-4f9a-7a22a75e0cc8@enterprisedb.com
Whole thread Raw
In response to Re: Fdw batch insert error out when set batch_size > 65535  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Fdw batch insert error out when set batch_size > 65535
List pgsql-hackers
On 6/9/21 3:28 PM, Tom Lane wrote:
> Tomas Vondra <tomas.vondra@enterprisedb.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



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: RFC: Logging plan of the running query
Next
From: David Christensen
Date:
Subject: Re: DELETE CASCADE