On 2015-07-01 11:19:40 +0100, Simon Riggs wrote: > What "tricks" are being used?? > > Please explain why taking 2 locks is bad here, yet works fine elsewhere.
I didn't say anything about 'bad'. It's more complicated than one lock. Suddenly you have to care about lock ordering and such. The algorithms for ensuring correctness gets more complicated. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers