On Wed, Jul 1, 2015 at 6:21 AM, Andres Freund <and...@anarazel.de> wrote: > 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.
Taking two locks might also be more expensive than just taking one. I suppose benchmarking will reveal whether there is an issue there. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
