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.