Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7BA199FC0DC for ; Wed, 30 May 2007 14:24:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 54697-06 for ; Wed, 30 May 2007 14:24:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by postgresql.org (Postfix) with ESMTP id 3A6D59FC0F8 for ; Wed, 30 May 2007 14:24:26 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so709712ana for ; Wed, 30 May 2007 10:24: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:in-reply-to:mime-version:content-type:references; b=cEaEQFitRW6FKKnBxU0N3YN0Y7wQwQkmRFFGUGmBua5k+cBbFxcyh/GlTzm8MdjfVRntH0jX53yN+CM4teqjimzXtRE3UmbL5SsTh0iV5vTP417N4/WIZqry5sthRtY49W1rQKMt8p98UKrsF/IkjoSQtG5uc20TYPsCrCUFnZM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=WdMKfzoP7wfap6SjSEAHDVfhs+c8/TGHAotU8+IOoZG/7BWWOuFDED/zt7/D5R8PF6aT4hkPaXp7JZDKVufp0GQ2HDSx17aCeny7toTf4l70VpIHAf9b++8ECjsQ9LOA24dwT9HntoFG/qdFHgRZ7we7+3tTWd2WpkU/0877z5s= Received: by 10.78.132.2 with SMTP id f2mr2316231hud.1180545854647; Wed, 30 May 2007 10:24:14 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Wed, 30 May 2007 10:24:14 -0700 (PDT) Message-ID: <1d219a6f0705301024p61aec66cv8b87adebfd4244a9@mail.gmail.com> Date: Wed, 30 May 2007 13:24:14 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: Fwd: Out of Memory on Reindex In-Reply-To: <1d219a6f0705290836h67b9509egc62498c78cf39829@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6732_24467516.1180545854560" References: <1d219a6f0705290836h67b9509egc62498c78cf39829@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/316 X-Sequence-Number: 25636 ------=_Part_6732_24467516.1180545854560 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Any ideas? ---------- Forwarded message ---------- From: Chris Hoover Date: May 29, 2007 11:36 AM Subject: Out of Memory on Reindex To: "pgsql-admin@postgresql.org" 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? Are we looking at work_mem, shmmax, or something else? Thanks, Chris PG 8.1.3 ------=_Part_6732_24467516.1180545854560 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Any ideas?

---------- Forwarded message ----------
From: Chris Hoover <revoohc@gmail.com>
Date: May 29, 2007 11:36 AM
Subject: Out of Memory on Reindex
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>

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?  Are we looking at work_mem, shmmax, or something else?

Thanks,

Chris

PG 8.1.3

------=_Part_6732_24467516.1180545854560--