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
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 |