Re: Locking in PostgreSQL? - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Locking in PostgreSQL?
Date
Msg-id 20061206133104.GA9537@uio.no
Whole thread Raw
In response to Re: Locking in PostgreSQL?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-performance
On Wed, Dec 06, 2006 at 08:26:45AM -0500, Dave Cramer wrote:
> Apparently I've completely misunderstood MVCC then.... My
> understanding is that unless you do a select ... for update then
> update the rows will not be locked .

The discussion was about updates, not selects. Selects do not in general lock
(except for ... for update, as you say).

To (partially) answer the original question: The number of columns updated
does not matter for the locking situation.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Locking in PostgreSQL?
Next
From: Markus Schiltknecht
Date:
Subject: Re: [GENERAL] Locking in PostgreSQL?