[GENERAL] configuring queries for concurrent updates

2012-06-22 Thread Robert Poor
[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

Re: [GENERAL] configuring queries for concurrent updates

2012-06-24 Thread Robert Poor
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