Re: Fdw batch insert error out when set batch_size > 65535

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Fdw batch insert error out when set batch_size > 65535
Дата
Msg-id 6abb33e8-db04-3d39-4f9a-7a22a75e0cc8@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Fdw batch insert error out when set batch_size > 65535  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Fdw batch insert error out when set batch_size > 65535  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: RFC: Logging plan of the running query
Следующее
От: David Christensen
Дата:
Сообщение: Re: DELETE CASCADE