Thread: ON CONFLICT Clause used on partition tables

ON CONFLICT Clause used on partition tables

From
Wasim Devale
Date:
Hi All

I encountered the insert clause "ON CONFLICT DO update" slowing down the insertion in the partition tables what might be the reason. I used timestamp partion key. 

I understand the uniqueness can not be maintained across all partions but the partion key must take care of it globally for inserting bulk data from CSV files.

Please help on this.

Thanks,
Wasim