On Thursday, April 28, 2011 11:44:37 PM Jeff Davis wrote: > On Thu, 2011-04-28 at 07:29 +0200, pasman pasmaÅski wrote: > > Hi. Yesterday i have an idea, that sometimes row locks may be skipped, > > when table is already locked with LOCK command. It may to reduce an > > overhead from row locks. > > What do you think about it? > be using row locks if they already have an EXCLUSIVE lock on the table. > Do you have a use-case in mind? It could possibly reduce the disk overhead of doing foreign key checks during large operations somewhat as fewer buffers would get dirtied. At least thats the situation where I thought about it before. Andres -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
