 | | From: | KÖPFERL_Robert | | Subject: | automatic table locking on too many locked records? | | Date: | Thu, 20 Jan 2005 17:39:39 +0100 |
|
|
 | Hi all and Michael.
An MS-SQL experienced developer warned me that on MS-SQLsvr a whole table
gets locked if a certain percentage or amount of records are locked due to
an update. And then shortly nothing goes.
Does there exist a similar behaviour on pgSQL? Get tables locked if too many
records are beein updated? Or something elses?
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
|
|
| | From: | Richard Huxton | | Subject: | Re: automatic table locking on too many locked records? | | Date: | Thu, 20 Jan 2005 17:01:00 +0000 |
|
|
| KÖPFERL Robert wrote:
> Hi all and Michael.
>
> An MS-SQL experienced developer warned me that on MS-SQLsvr a whole table
> gets locked if a certain percentage or amount of records are locked due to
> an update. And then shortly nothing goes.
> Does there exist a similar behaviour on pgSQL? Get tables locked if too many
> records are beein updated? Or something elses?
PostgreSQL's MVCC system means updates generally don't lock at all. For
more info, Google for MVCC and check the manual for Transaction
Isolation Levels.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
|
|
