Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BF93B9FC0B0 for ; Thu, 31 May 2007 11:07:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 18097-09 for ; Thu, 31 May 2007 11:07:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.225]) by postgresql.org (Postfix) with ESMTP id A5E8A9FB5BB for ; Thu, 31 May 2007 11:07:16 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so159561wri for ; Thu, 31 May 2007 07:07:15 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=AipStGtm4YFgBNevt93JV/liTKIZe3XVoVN7oN4AhoUnC9x4AzLx7sZRBxrBACgrhqBUrHhLeax/Ak0SPVcbnNUXlEA9joiAmp0C47fj/FrTCm4VqFxGvmxrd4um9J7yap7NnvRpveQPm6K3W4cJKGTsk1991vfcJvqJ4pp/sYQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=GrDfL2bQUlBWkY9QdGZ3hXzfgh6evEt+aDuEe6cdtHjIisijVeS2VQGqtLc77R62WsOr5H0EpQNVEgCdrBvor1mVBn740atNHXW/M0YHqJ/LqTTQW0+Sr4R0DqZY9u2QPGwhJP/V22GI1myOgUw7Eui2pKBKOtLB5TeZwAzlU7U= Received: by 10.78.142.14 with SMTP id p14mr420798hud.1180620434916; Thu, 31 May 2007 07:07:14 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Thu, 31 May 2007 07:07:14 -0700 (PDT) Message-ID: <1d219a6f0705310707i73292913rdccd98f591529776@mail.gmail.com> Date: Thu, 31 May 2007 10:07:14 -0400 From: "Chris Hoover" To: "Tom Lane" Subject: Re: Fwd: Out of Memory on Reindex Cc: "pgsql-admin@postgresql.org" In-Reply-To: <21900.1180562115@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17294_15854378.1180620434878" References: <1d219a6f0705290836h67b9509egc62498c78cf39829@mail.gmail.com> <1d219a6f0705301024p61aec66cv8b87adebfd4244a9@mail.gmail.com> <21900.1180562115@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/330 X-Sequence-Number: 25650 ------=_Part_17294_15854378.1180620434878 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline maintenance_work_mem = 1048576 (I have 9GB ram on this server). Chris On 5/30/07, Tom Lane wrote: > > "Chris Hoover" writes: > > I am getting the following error when trying to run a reindex on one of > my > > databases. > > > reindexdb: reindexing of database "xxx" failed: ERROR: out of memory > > DETAIL: Failed on request of size 268435456. > > > Can someone advise on what memory parameter was violated? > > Kernel's process size limit (ulimit -m or something like that). > > What have you got maintenance_work_mem set to ... 256MB by any chance? > If so make it less. > > regards, tom lane > ------=_Part_17294_15854378.1180620434878 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline maintenance_work_mem = 1048576 (I have 9GB ram on this server).

Chris

On 5/30/07, Tom Lane <tgl@sss.pgh.pa.us > wrote:
"Chris Hoover" <revoohc@gmail.com > writes:
> I am getting the following error when trying to run a reindex on one of my
> databases.

> reindexdb: reindexing of database "xxx" failed: ERROR:  out of memory
> DETAIL:  Failed on request of size 268435456.

> Can someone advise on what memory parameter was violated?

Kernel's process size limit (ulimit -m or something like that).

What have you got maintenance_work_mem set to ... 256MB by any chance?
If so make it less.

                        regards, tom lane

------=_Part_17294_15854378.1180620434878--