"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> Seems like we should try to locate a row first, then INSERT if we cannot
> find one. That's slower on INSERT but more balanced overall
Except it still has the race condition.
> I'm a bit surprised the TODO didn't mention the MERGE statement, which
> is the SQL:2003 syntax for specifying this as an atomic statement.
I believe we concluded that MERGE doesn't actually do quite what people
want/expect. Please go back and read the archives.
regards, tom lane