From: | "Marcelo Costa" <marcelojscosta(at)gmail(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: How much memory in 32 bits Architecture to Shared Buffers is Possible |
Date: | 2006-10-02 16:31:51 |
Message-ID: | c13f2d590610020931x1b8a084bp45e137b838872493@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Yes, my system is DEBIAN SARGE 3.0
thanks,
Marcelo
2006/10/2, Joshua D. Drake <jd(at)commandprompt(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | uwcssa | 2006-10-02 17:36:17 | Unsubscribe |
Previous Message | Joshua D. Drake | 2006-10-02 16:26:07 | Re: How much memory in 32 bits Architecture to Shared Buffers |