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