Re: Stripping kernel FreeBSD - postgres

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