ON CONFLICT Clause used on partition tables

From: Wasim Devale <wasimd60(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: ON CONFLICT Clause used on partition tables
Date: 2024-11-07 09:16:26
Message-ID: CAB5fag5qfKqQLh52NbvRT1TmALC6dSx1wfLfrLSmHueYAYQx-Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2024-11-07 13:43:02 Re: \i and \watch
Previous Message Wasim Devale 2024-11-07 09:08:05 Re: Bytea datatype content to view