Postgres Pro
Downloads
Home   >   mailing lists

FreeBSD kernel configuration - Mailing list pgsql-general

From veejar
Subject FreeBSD kernel configuration
Date
Msg-id a4c4d7e50703060042o4e36a899t53d1f7a3bf2b7b4e@mail.gmail.com
Whole thread Raw
Responses Re: FreeBSD kernel configuration  (Vivek Khera <vivek@khera.org>)
List pgsql-general
Tree view 
Hi!

I have server such configuration:
2 x Xeon LV DualCore 1.66GHz
MEM 4Gb DDR2-400
2 x 250Gb SATA HDD

I have 20 databases on PostgreSQL 8.
2 of them are more than 1GB.
I have ~50 requests per second.

What kernel setting can you recommend me?

in /boot/loader.conf ???
kern.ipc.semmni=
kern.ipc.semmns=
kern.ipc.semmnu=

and in /etc/sysctl.conf ???
kern.ipc.shmall=
kern.ipc.shmmax=
kern.ipc.semmap=

--
Vadim

pgsql-general by date:

Previous
From: brian
Date:
Subject: Re: Wikipedia on Postgres (was Re: postgresql vs mysql)
Next
From: "Premsun Choltanwanich"
Date:
Subject: Does it has a way to compact the database size?