Postgres Pro
Downloads
Home   >   mailing lists

ON CONFLICT Clause used on partition tables - Mailing list pgsql-admin

From Wasim Devale
Subject ON CONFLICT Clause used on partition tables
Date
Msg-id CAB5fag5qfKqQLh52NbvRT1TmALC6dSx1wfLfrLSmHueYAYQx-Q@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: Re: Bytea datatype content to view
Next
From: Tom Lane
Date:
Subject: Re: \i and \watch