Re: How much memory in 32 bits Architecture to Shared Buffers is Possible - Mailing list pgsql-performance

From Marcelo Costa
Subject Re: How much memory in 32 bits Architecture to Shared Buffers is Possible
Date
Msg-id c13f2d590610020931x1b8a084bp45e137b838872493@mail.gmail.com
Whole thread Raw
In response to Re: How much memory in 32 bits Architecture to Shared Buffers  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
Yes, my system is DEBIAN SARGE 3.0

thanks,

Marcelo

2006/10/2, Joshua D. Drake <jd@commandprompt.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/





--
Marcelo Costa

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: How much memory in 32 bits Architecture to Shared Buffers
Next
From: uwcssa
Date:
Subject: Unsubscribe