Postgres Pro
Downloads
Home   >   mailing lists

automatic table locking on too many locked records? - Mailing list pgsql-sql

From KÖPFERL Robert
Subject automatic table locking on too many locked records?
Date
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB1657A@neptun.sonorys.at
Whole thread Raw
Responses Re: automatic table locking on too many locked records?  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
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?

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: ERROR: row is too big: size 9856, maximum size 8136
Next
From: Michael Fuhr
Date:
Subject: Re: OID's