[std_disclaimer]I'm not a DBA and I'm running PostgreSQL on a
quad-core Intel laptop. You may read on after you stop
laughing...[/std_disclaimer]
I've written a version of UPSERT designed to import a large number of
records. It works in two steps: it UPDATEs incumbent records that
share common k
Craig:
On Sun, Jun 24, 2012 at 12:06 AM, Craig Ringer wrote:
> That [implementation of UPSERT] is incorrect; it's subject to several nasty
> races.
> The best article I've seen on this is here:
>
> http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/
You're right -- that's a thorough