Re: Stripping kernel FreeBSD - postgres

[Walter Vaughan <wvaughan(at)steelerubber(dot)com>]

Enrico wrote:

> HI,
> I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres 
> installed.
> Where can I have any info about?

Opimizing the FreeBSD kernel?

Obviouly you want to start with a machine with a much memory as you can afford, 
as fast a disk subsystem you can afford, and as powerful a CPU you can afford.
Then rip a boot only CD, and do a minimal install with the ports collection.

FreeBSD 6.1 is pretty optimized already, and it will adapt. Have you followed 
the directions for building a custom kernel?
http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/kernelconfig-building.html
Don't include hardware you don't have is obvious to strip from the GENERIC 
kernel configuration file, and make build for SMP if you have real dual cores or 
processors if you have them (a single CPU with hyperthreading most likely will 
not run as fast under an SMP kernel).

As far as any other tweeking, follow the directions here and don't do anything
http://www.freebsd.org/doc/en_US.ISO8859-1/books/arch-handbook/vm-tuning.html

Then as root user
cd /usr/ports/databases/postgresql81-server/ && make install clean
and enjoy your posgreSQL/freeBSD server.

--
Walter