automatic table locking on too many locked records?

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: automatic table locking on too many locked records?
Date: 2005-01-20 16:39:39
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB1657A@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-01-20 16:48:30 Re: OID's
Previous Message Alex Turner 2005-01-20 16:39:16 Re: [SQL] OFFSET impact on Performance???