Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A6BBB9FB88D for ; Thu, 31 May 2007 12:07:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 65213-02 for ; Thu, 31 May 2007 12:07:29 -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.243]) by postgresql.org (Postfix) with ESMTP id 5B4699FB6A0 for ; Thu, 31 May 2007 12:07:34 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so72692ana for ; Thu, 31 May 2007 08:07:33 -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=ZWI4ORGySHGoaCmPhDPfj951NeEeqtjLtgWpcFktjXvOWdv24OmlCVqawf3SCHGV9MsVuPExfBg3Ra168MraFU5pnz99mSZcOUlQGJjAwBqcDm0/YxPpg2wsxylls31uaqJ5iD8sHs2CN+FYxa7dg94CwSwKy/6MtIdqP2G8NbM= 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=eF7bEsDoGKnj5YXG+pSPN10lkR2ZYWo97bzuSW3X09fki4asA879xsemz91Ybhj80Sz3qi4oDm1cnm3Hnfh99zo1AnunGYjSkyhfDQLEvXn/lb1ysnT9ZpUwEN0Wk9w2fNA6IZa99wLj41uNn/JTkLaQgqo0oqlQn917tDdKBnM= Received: by 10.78.181.13 with SMTP id d13mr481925huf.1180624052365; Thu, 31 May 2007 08:07:32 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Thu, 31 May 2007 08:07:32 -0700 (PDT) Message-ID: <1d219a6f0705310807r48bb141cy8ef5c77f49ac6196@mail.gmail.com> Date: Thu, 31 May 2007 11:07:32 -0400 From: "Chris Hoover" To: "Tom Lane" Subject: Re: Fwd: Out of Memory on Reindex Cc: "pgsql-admin@postgresql.org" In-Reply-To: <29387.1180622575@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17915_15748173.1180624052317" References: <1d219a6f0705290836h67b9509egc62498c78cf39829@mail.gmail.com> <1d219a6f0705301024p61aec66cv8b87adebfd4244a9@mail.gmail.com> <21900.1180562115@sss.pgh.pa.us> <1d219a6f0705310707i73292913rdccd98f591529776@mail.gmail.com> <29387.1180622575@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/333 X-Sequence-Number: 25653 ------=_Part_17915_15748173.1180624052317 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry for not providing that info Here are the ulimits for my postgres account: [postgres@dbserver ~]$ ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 159744 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited This is on a 32bit dual HT Xeon system using the official rpms. Chris P.S. Sorry for the direct reply, forgot to hit reply all. On 5/31/07, Tom Lane wrote: > > "Chris Hoover" writes: > > maintenance_work_mem = 1048576 (I have 9GB ram on this server). > > You might have that much RAM, but I wonder how much of it the kernel > will give to any one process. Did you check the ulimit settings the > postmaster is running under? Is it possibly a 32-bit rather than > 64-bit build of Postgres? > > regards, tom lane > ------=_Part_17915_15748173.1180624052317 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry for not providing that info  Here are the ulimits for my postgres account:
[postgres@dbserver ~]$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
file size               (blocks, -f) unlimited
pending signals                 (-i) 1024
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 159744
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

This is on a 32bit dual HT Xeon system using the official rpms.

Chris

P.S.

Sorry for the direct reply, forgot to hit reply all.

On 5/31/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Chris Hoover" <revoohc@gmail.com> writes:
> maintenance_work_mem = 1048576 (I have 9GB ram on this server).

You might have that much RAM, but I wonder how much of it the kernel
will give to any one process.  Did you check the ulimit settings the
postmaster is running under?  Is it possibly a 32-bit rather than
64-bit build of Postgres?

                        regards, tom lane

------=_Part_17915_15748173.1180624052317--