[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: ON CONFLICT DO NOTHING ignored on bulk insert
From:       Michael Lewis <mlewis () entrata ! com>
Date:       2021-05-25 15:41:42
Message-ID: CAHOFxGryjbEkS6pT+1WW1Z0j5GWF=zO5LHRNyon54a63XMKo4g () mail ! gmail ! com
[Download RAW message or body]

Are you wanting to minimize the locking time, or ensure the whole process
completes as soon as possible? If the prior, you can insert into a temp
table like the real one (which is maybe what pricelistnew is already),
delete the rows where they don't have a valid reference, and then insert
all remaining rows.

[Attachment #3 (text/html)]

<div dir="ltr">Are you wanting to minimize the locking time, or ensure the whole \
process completes as soon as possible? If the prior, you can insert into a temp table \
like the real one (which is maybe what pricelistnew is already), delete the rows \
where they don&#39;t have a valid reference, and then insert all remaining \
rows.<div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]