RE: Parallel INSERT (INTO ... SELECT ...) - Mailing list pgsql-hackers

From tsunakawa.takay@fujitsu.com
Subject RE: Parallel INSERT (INTO ... SELECT ...)
Date
Msg-id OSBPR01MB29823755AC1E0A21D4CD736DFEA40@OSBPR01MB2982.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Parallel INSERT (INTO ... SELECT ...)  (Amit Kapila <amit.kapila16@gmail.com>)
Responses RE: Parallel INSERT (INTO ... SELECT ...)  ("Tang, Haiying" <tanghy.fnst@cn.fujitsu.com>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: Key management with tests
Next
From: Tatsuo Ishii
Date:
Subject: Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits