Postgresql UPDATE LOCKS unrelated rows.

From: "Ravi T Ramachandra" <ravi(dot)ramachandra(at)wipro(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Postgresql UPDATE LOCKS unrelated rows.
Date: 2003-09-18 06:43:01
Message-ID: 4223A04BF7D1B941A25246ADD0462FF5D27E9B@blr-m3-msg.wipro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,

We are using postgresql 7.3.2 on lunux platform. We performed locking
test as follows via JDBC:

Started 2 concurrent transaction with autocommit false and isolation
READ_COMMITTED :

Transaction 1:
===========
Update row 1
Sleep for 30 seconds
commit:

Transaction 2:
===========
Updated row 10000
commit

The second update had to wait for the first update operation to finish.
We also made sure that the 2 unrelated rows are not on the same page.

Is this expected behavior ?
Does update lock the whole table ?

Regards,
Ravi


**************************Disclaimer************************************

Information contained in this E-MAIL being proprietary to Wipro Limited is
'privileged' and 'confidential' and intended for use only by the individual
or entity to which it is addressed. You are notified that any use, copying
or dissemination of the information contained in the E-MAIL in any manner
whatsoever is strictly prohibited.

***************************************************************************

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Callan 2003-09-18 09:01:41 initdb problem
Previous Message A.Bhuvaneswaran 2003-09-18 04:52:15 Re: how to find multi-byte is enabled or not for 7.2.3