On 9 November 2018 at 18:45, Amit Langote wrote:
> As long as queries involve tuple routing that touches multiple not yet
> seen partitions, someone doing conflicting operations directly on multiple
> partitions in a transaction will have to be ready to see deadlocks.
> Maybe, we can document
Friday, November 9, 2018 11:20 AM
> To: Kato, Sho/加藤 翔 ; Amit Langote
> ; Robert Haas
> Cc: PostgreSQL Hackers
> Subject: Re: Performance improvements of INSERTs to a partitioned table
>
> On 7 November 2018 at 21:31, Kato, Sho wrote:
> > AFAIK, When CREATE INDEX on a par
On 2018/11/09 11:19, David Rowley wrote:
> On 7 November 2018 at 21:31, Kato, Sho wrote:
>> AFAIK, When CREATE INDEX on a partition and INSERT to a parent table are
>> executed at the same time, this patch causes deadlock.
>>
>> * partitions information
>>
>> Partition key: RANGE (a)
>>
On 7 November 2018 at 21:31, Kato, Sho wrote:
> AFAIK, When CREATE INDEX on a partition and INSERT to a parent table are
> executed at the same time, this patch causes deadlock.
>
> * partitions information
>
> Partition key: RANGE (a)
> Partitions: a_1 FOR VALUES FROM (1) TO (100),
>
AFAIK, When CREATE INDEX on a partition and INSERT to a parent table are
executed at the same time, this patch causes deadlock.
* partitions information
Partition key: RANGE (a)
Partitions: a_1 FOR VALUES FROM (1) TO (100),
a_2 FOR VALUES FROM (100) TO (200)
T1: create index a_1_ix
