Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 66A1765034D for ; Wed, 6 Aug 2008 09:32:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 86504-03 for ; Wed, 6 Aug 2008 09:32:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id 056526502D4 for ; Wed, 6 Aug 2008 09:32:40 -0300 (ADT) Received: from congw.dc1.conova.com ([217.196.145.250] helo=[192.168.1.61]) by cronos.madness.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1KQiBs-0006Yt-Ib; Wed, 06 Aug 2008 14:32:35 +0200 Message-ID: <48999A0E.7040007@kaltenbrunner.cc> Date: Wed, 06 Aug 2008 14:33:18 +0200 From: Stefan Kaltenbrunner User-Agent: Icedove 1.5.0.14eol (X11/20080724) MIME-Version: 1.0 To: Marcin Citowicki CC: pgsql-performance@postgresql.org Subject: Re: pg_dump error - out of memory, Failed on request of size 536870912 References: <48997383.3040704@m4n.nl> <48997C5F.6030702@m4n.nl> In-Reply-To: <48997C5F.6030702@m4n.nl> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/18 X-Sequence-Number: 30899 Marcin Citowicki wrote: > Hello, > > I forgot to add - all those 'out of memory' errors happen when backup db > is trying to create index. Every 'CREATE INDEX' operation is followed by > 'out of memory' error. are you sure that your OS (or ulimit) is able to support a maintenance_work_setting that large ? - try reducing to a say 128MB for a start and try again. Stefan