How much memory in 32 bits Architecture to Shared Buffers is Possible

pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed

How much memory in 32 bits Architecture to Shared Buffers is Possible
3+ messages / 2 participants
[nested] [flat]

* How much memory in 32 bits Architecture to Shared Buffers is Possible
@ 2006-10-02 15:49 Marcelo Costa <marcelojscosta@gmail.com>
  2006-10-02 16:26 ` Re: How much memory in 32 bits Architecture to Shared Buffers Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Marcelo Costa @ 2006-10-02 15:49 UTC (permalink / raw)
  To: pgsql-performance

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.

I try change these shared memory values to use 25% of memory ram (2048
MB) and effective_cache_size to 50% (4096 MB) of memory. All this
settings to 220 Max Connections.

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.

Only with 15% of value on shared memory i can start up this cluster.
In my tests the maximum value who i can put is 1.9 GB, more of this
the cluster don't start.

Can anybody help me and explicate if exist one limit to memory on 32
bits Architecture.

Anybody was experience with tuning servers with this configurations
and increasing ?

thanks to all.

-- 
Marcelo Costa

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How much memory in 32 bits Architecture to Shared Buffers
  2006-10-02 15:49 How much memory in 32 bits Architecture to Shared Buffers is Possible Marcelo Costa <marcelojscosta@gmail.com>
@ 2006-10-02 16:26 ` Joshua D. Drake <jd@commandprompt.com>
  2006-10-02 16:31   ` Re: How much memory in 32 bits Architecture to Shared Buffers is Possible Marcelo Costa <marcelojscosta@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Joshua D. Drake @ 2006-10-02 16:26 UTC (permalink / raw)
  To: Marcelo Costa <marcelojscosta@gmail.com>; +Cc: pgsql-performance

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/

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: How much memory in 32 bits Architecture to Shared Buffers is Possible
  2006-10-02 15:49 How much memory in 32 bits Architecture to Shared Buffers is Possible Marcelo Costa <marcelojscosta@gmail.com>
  2006-10-02 16:26 ` Re: How much memory in 32 bits Architecture to Shared Buffers Joshua D. Drake <jd@commandprompt.com>
@ 2006-10-02 16:31   ` Marcelo Costa <marcelojscosta@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Marcelo Costa @ 2006-10-02 16:31 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: 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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2006-10-02 16:31 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-02 15:49 How much memory in 32 bits Architecture to Shared Buffers is Possible Marcelo Costa <marcelojscosta@gmail.com>
2006-10-02 16:26 ` Re: How much memory in 32 bits Architecture to Shared Buffers Joshua D. Drake <jd@commandprompt.com>
2006-10-02 16:31   ` Marcelo Costa <marcelojscosta@gmail.com>

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