From: | Anj Adu <fotographs(at)gmail(dot)com> |
---|---|
To: | Tino Schwarze <postgresql(at)tisc(dot)de> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Setting Shared-Buffers |
Date: | 2009-07-10 21:26:48 |
Message-ID: | f2fd819a0907101426s6d81c66dn5f523c41d498b082@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
You can use upto 64G of RAM on a 32 bit RHEL 5/ Fedora 8 OS using the kernel
PAE extension.
On Thu, Jul 9, 2009 at 3:29 PM, Tino Schwarze <postgresql(at)tisc(dot)de> wrote:
> Hi Rafael,
>
> On Thu, Jul 09, 2009 at 07:18:55PM -0300, Rafael Domiciano wrote:
>
> > Today, I've upgraded a dedicated postgres server, from 2 Gb to 10 Gb.
> > Everything gone well.
> >
> > But, I would like shared buffers to use at least 5 Gb of the total
> memory.
> > Setting kernel.shmmax with 6291456000 (6000 Mb) is not working properly,
> the
> > server is changing the value to a small one.
> > So I can't set the shared buffers to the value that I want.
> >
> > Now, just momently, the server is running with only 2 Gb of shared
> buffers,
> > but I want to use all the capacity of the server/memory.
> >
> > Can anyone help you,
> >
> > Linux Fedora Core 9
> > postgres=# select version();
> > version
> >
> ---------------------------------------------------------------------------------------------------
> > PostgreSQL 8.3.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.0
> > 20080428 (Red Hat 4.3.0-8)
>
> You cannot use more than 3.something GB of memory on a 32 bit system. A
> single process is limited to IIRC 3.5 GB of address space on such
> systems and shared memory is part of it's address space. If the server
> supports such amounts of memory, it is likely that you may run a 64 bit
> OS on it. (Note: You need a full dump/restore of the whole PostgreSQL DB
> space if you switch to 64 bit.)
>
> HTH,
>
> Tino.
>
> --
> "What we nourish flourishes." - "Was wir nähren erblüht."
>
> www.lichtkreis-chemnitz.de
> www.craniosacralzentrum.de
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Ivanov | 2009-07-10 21:30:42 | Re: Setting kernel.shmmax |
Previous Message | Dimitri Fontaine | 2009-07-10 19:50:01 | Re: Installing Postgresql on Debian (-E parameter question) |