RE: Parallel Inserts in CREATE TABLE AS

Поиск
Список
Период
Сортировка
От tanghy.fnst@fujitsu.com
Тема RE: Parallel Inserts in CREATE TABLE AS
Дата
Msg-id OS0PR01MB6113F6FF2B6BC473BDEC8B47FB689@OS0PR01MB6113.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Parallel Inserts in CREATE TABLE AS  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Ответы Re: Parallel Inserts in CREATE TABLE AS  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Список pgsql-hackers
From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
>I analyzed performance of parallel inserts in CTAS for different cases
>with tuple size 32bytes, 59bytes, 241bytes and 1064bytes. We could
>gain if the tuple sizes are lower. But if the tuple size is larger
>i..e 1064bytes, there's a regression with parallel inserts.

Thanks for the update.
BTW, May be you have some more testcases that can reproduce this regression easily.
Can you please share some of the testcase (with big tuple size) with me.

Regards,
Tang



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Allow an alias to be attached directly to a JOIN ... USING
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: About to add WAL write/fsync statistics to pg_stat_wal view