X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F055C3A2C54 for ; Thu, 20 Jan 2005 17:01:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45943-07 for ; Thu, 20 Jan 2005 17:01:25 +0000 (GMT) Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by svr1.postgresql.org (Postfix) with ESMTP id C9B873A1CF7 for ; Thu, 20 Jan 2005 17:01:24 +0000 (GMT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-30.mail.demon.net with esmtp (Exim 4.42) id 1CrfgI-000Fpv-27; Thu, 20 Jan 2005 17:01:18 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 8B5AC170C3; Thu, 20 Jan 2005 17:00:57 +0000 (GMT) Message-ID: <41EFE3CC.8040303@archonet.com> Date: Thu, 20 Jan 2005 17:01:00 +0000 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: =?ISO-8859-1?Q?K=D6PFERL_Robert?= Cc: pgsql-sql@postgresql.org Subject: Re: automatic table locking on too many locked records? References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.075 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/176 X-Sequence-Number: 19964 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