Re: Stripping kernel FreeBSD - postgres

Enrico wrote:
>> http://www.freebsd.org/doc/it_IT.ISO8859-15/books/handbook/kernelconfig.html
>>
>
> Hi Bill
> I already read your link and it is not specific for Postgres, I'm searching for a
> more specific document.

You'll probably want a lot of shared memory, but you can set that using
sysctls.
If you're on a multi-cpu system, you'll want SMP.
If you're on a hyperthreading machine, you'll have to choose whether you
want that on or off (don't know what's best for PostgreSQL).
If you're on a 32-bit platform with lots of RAM, you may need PAE.
Other than that, I really wouldn't know.

What kind of kernel options do you expect to have any impact on database
performance?

You could build a couple of different kernels with different configs and
see what works best for you. I suppose hyper-threading or not and PAE or
not are the best candidates for experimentation.

I know there're quite a few FreeBSD users among the people here and I've
always kinda disliked system administration, so I suspect I'm not the
best candidate for answering your question :P
--
Alban Hertroys
alban(at)magproductions(dot)nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede

// Integrate Your World //