On Wed, Jul 1, 2015 at 6:21 AM, Andres Freund <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
