From: Richard Huxton <dev@archonet.com>
To: KÖPFERL Robert <robert.koepferl@sonorys.at>
Cc: pgsql-sql@postgresql.org
Subject: Re: automatic table locking on too many locked records?
Date: Thu, 20 Jan 2005 17:01:00 +0000
Message-ID: <41EFE3CC.8040303@archonet.com> (raw)
In-Reply-To: <ED4E30DD9C43D5118DFB00508BBBA76EB1657A@neptun.sonorys.at>
References: <ED4E30DD9C43D5118DFB00508BBBA76EB1657A@neptun.sonorys.at>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, robert.koepferl@sonorys.at
Subject: Re: automatic table locking on too many locked records?
In-Reply-To: <41EFE3CC.8040303@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox