From: Joshua D. Drake <jd@commandprompt.com>
To: Marcelo Costa <marcelojscosta@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How much memory in 32 bits Architecture to Shared Buffers
Date: Mon, 02 Oct 2006 09:26:07 -0700
Message-ID: <45213D9F.1020109@commandprompt.com> (raw)
In-Reply-To: <c13f2d590610020849t36b9ba4q6b591732d56e16bb@mail.gmail.com>
References: <c13f2d590610020849t36b9ba4q6b591732d56e16bb@mail.gmail.com>
Marcelo Costa wrote:
> Hi, to all!
>
> Recently i try increasing the memory values of shared buffers on one
> IBM xseries 255 (Quad XEON 2.8, 8 GB RAM, 2 disk SCSI 36 GB(Raid 1), 1
> Storage.
You haven't specified your OS so I am going to assume Linux.
> Where I start up the cluster very messages of configurations errors on
> shared_memmory and SHMMAX look up. I try change the values of
> shared_memory, max_connections and effective_cache_size and large the
> size of SHMALL and SHMMAX to use 4294967296 (4096 MB) but the cluster
> don't start.
You have to edit your sysctl.conf see:
http://www.postgresql.org/docs/8.1/static/runtime.html
I *think* (I would have to double check) the limit for shared memory on
linux 32bit is 2 gig. Possibly 2 gig per CPU I don't recall. I run all
64bit now.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, marcelojscosta@gmail.com
Subject: Re: How much memory in 32 bits Architecture to Shared Buffers
In-Reply-To: <45213D9F.1020109@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox