On 2 February 2015 at 14:32, Geoff Winkless <pgsqladmin(at)geoff(dot)dj> wrote:
> Mmmf. So I would have to make sure that my source tuples were unique
> before doing the INSERT (otherwise the first ON CONFLICT UPDATE for a
> tuple would block any other)? That's potentially very slow :(
Replying to my own message, because it occurs to me I might be being
stupid (surely not :) )
When you say "this will still lock the unmodified row" did you mean
just that it's locked to _other_ processes until commit? That would be
much less impactful.
Geoff