| From: | Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Setting Shared-Buffers |
| Date: | 2009-07-09 22:18:55 |
| Message-ID: | 3a0028490907091518r33b70581rda7400ce85856925@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tino Schwarze | 2009-07-09 22:29:03 | Re: Setting Shared-Buffers |
| Previous Message | Dimitri Fontaine | 2009-07-09 19:38:50 | Re: Installing Postgresql on Debian (-E parameter question) |