Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 072032E48B5 for ; Thu, 24 Jan 2008 22:24:52 -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 88612-03-6 for ; Thu, 24 Jan 2008 22:24:39 -0400 (AST) Received: from mail.midstorm.org (mail.midstorm.org [65.99.212.143]) by postgresql.org (Postfix) with ESMTP id 151AF2E59C8 for ; Thu, 24 Jan 2008 21:11:53 -0400 (AST) Received: from pmanson (201-24-48-227.bsace703.dsl.brasiltelecom.net.br [201.24.48.227]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.midstorm.org (Postfix) with ESMTP id A9356403BB for ; Thu, 24 Jan 2008 23:11:51 -0200 (BRST) Date: Thu, 24 Jan 2008 23:14:33 -0200 From: Fernando Ike To: pgsql-performance@postgresql.org Subject: Re: 8.3rc1 Out of memory when performing update Message-ID: <20080124231433.2f312549@pmanson> In-Reply-To: References: X-Mailer: Claws Mail 3.2.0 (GTK+ 2.12.5; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/224 X-Sequence-Number: 28463 Em Fri, 25 Jan 2008 12:46:20 +1300 "Stephen Denne" escreveu: > 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? > I believe that it is plataform problem. Because on *nix this limit don't occur. But I don't specialist Windows. Kind Regards, -- Fernando Ike http://www.midstorm.org/~fike/weblog