Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D552B2E30A3 for ; Thu, 24 Jan 2008 23:22:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 13605-01-7 for ; Thu, 24 Jan 2008 23:22:43 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 6CC7C2E5784 for ; Thu, 24 Jan 2008 22:31:20 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m0P2VEat021676; Thu, 24 Jan 2008 21:31:14 -0500 (EST) To: "Stephen Denne" cc: pgsql-performance@postgresql.org Subject: Re: 8.3rc1 Out of memory when performing update In-reply-to: References: Comments: In-reply-to "Stephen Denne" message dated "Fri, 25 Jan 2008 12:46:20 +1300" Date: Thu, 24 Jan 2008 21:31:14 -0500 Message-ID: <21675.1201228274@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/227 X-Sequence-Number: 28466 "Stephen Denne" writes: > A simple update query, over roughly 17 million rows, populating a newly added column in a table, resulted in an out of memory error when the process memory usage reached 2GB. Could this be due to a poor choice of some configuration parameter, or is there a limit on how many rows I can update in a single statement? Do you have any triggers or foreign keys on that table? For that matter, let's see its whole schema definition. regards, tom lane