Setting Shared-Buffers - Mailing list pgsql-admin

From Rafael Domiciano
Subject Setting Shared-Buffers
Date
Msg-id 3a0028490907091518r33b70581rda7400ce85856925@mail.gmail.com
Whole thread Raw
Responses Re: Setting Shared-Buffers
Re: Setting Shared-Buffers
List pgsql-admin
Hello People,

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)
(1 row)


Thnks,

Rafael Domiciano

pgsql-admin by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Installing Postgresql on Debian (-E parameter question)
Next
From: Tino Schwarze
Date:
Subject: Re: Setting Shared-Buffers