Shared_buffers and kernel parameters, tuning

From: "Lending, Rune" <rune(dot)lending(at)inpoc(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Shared_buffers and kernel parameters, tuning
Date: 2003-06-05 08:10:49
Message-ID: A177ACC01D78D4118FC100508BAE3F7A804F96@TELECOMMAIL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

After days of searching and testing I have come up with this way of
configuring our postgresql 7.2 db.
I have not yet increased my shared_buffer as high as suggested below on our
prod machine (24-7 high traffic), but after testing on our dev machines
this allows at least the databse to start up. It is very difficult to test
the actual performance since there is a hugh difference in traffic on dev
and prod.
Here is what we have:

We have a high traffic system with a database described as followed:

4 pentium 3 633 cpu's
3753456 kB RAM (3.5 Gb)
Red Hat Linux 7.2
postgresql 7.2

What I like to do is:

/proc/sys/kernel/sem=250 32000 100 500 (after advise from forum/docs)
/proc/sys/kernel/shmmax=1921769472 (RAM / 2 * 1024 - this
piece of math I got from some of oracle's support pages (ooopps) actually )

/proc/sys/kernel/shmall=1921769472 (RAM / 2 * 1024)

in postgresql.conf:

shared_buffers = 117248 (shmmax / 2 / 1024 / 8 ) This I got from this forum.

Does this sound right or am I totally out of bounds here? I have, as said
before done this on our dev macine ( a lot smaller machine ), but it would
be nice with some feedback ..

Thanx in advance for response.

/rune

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marvin 2003-06-05 08:41:27 No acceptable C compiler found
Previous Message Victor Yegorov 2003-06-05 07:28:05 Re: ALTER TABLE