RE: Parallel INSERT (INTO ... SELECT ...)

Поиск
Список
Период
Сортировка
От tsunakawa.takay@fujitsu.com
Тема RE: Parallel INSERT (INTO ... SELECT ...)
Дата
Msg-id OSBPR01MB29823755AC1E0A21D4CD736DFEA40@OSBPR01MB2982.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Parallel INSERT (INTO ... SELECT ...)  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы RE: Parallel INSERT (INTO ... SELECT ...)  ("Tang, Haiying" <tanghy.fnst@cn.fujitsu.com>)
Список pgsql-hackers
Hello Tang-san,

From: Amit Kapila <amit.kapila16@gmail.com>
> Can we test cases when we have few rows in the Select table (say 1000)
> and there 500 or 1000 partitions. In that case, we won't select
> parallelism but we have to pay the price of checking parallel-safety
> of all partitions. Can you check this with 100, 200, 500, 1000
> partitions table?

I also wanted to see such an extreme(?) case.  The 1,000 rows is not the count per partition but the total count of all
partitions.e.g.,when # of partitions is 100, # of rows per partition is 10.
 



Regards
Takayuki Tsunakawa


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Key management with tests
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits