Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 8F4539FA16B for ; Wed, 6 Dec 2006 08:29:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 13380-05 for ; Wed, 6 Dec 2006 08:29:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id 2687E9F9F7B for ; Wed, 6 Dec 2006 08:29:33 -0400 (AST) Received: (qmail 14518 invoked from network); 6 Dec 2006 12:29:32 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.14?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 6 Dec 2006 12:29:32 -0000 In-Reply-To: <1165388652.6396.1.camel@panoramix> References: <1165388652.6396.1.camel@panoramix> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <30BD1C9A-1664-4290-B343-0FB1FEBA7B53@fastcrypt.com> Cc: pgsql-general@postgresql.org, pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: [PERFORM] Locking in PostgreSQL? Date: Wed, 6 Dec 2006 07:29:37 -0500 To: Joost Kraaijeveld X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/252 X-Sequence-Number: 105191 Unless you specifically ask for it postgresql doesn't lock any rows when you update data. Dave On 6-Dec-06, at 2:04 AM, Joost Kraaijeveld wrote: > Does PostgreSQL lock the entire row in a table if I update only 1 > column? > > > -- > Groeten, > > Joost Kraaijeveld > Askesis B.V. > Molukkenstraat 14 > 6524NB Nijmegen > tel: 024-3888063 / 06-51855277 > fax: 024-3608416 > web: www.askesis.nl > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >