From: | Walter Vaughan <wvaughan(at)steelerubber(dot)com> |
---|---|
To: | Pg general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Stripping kernel FreeBSD - postgres |
Date: | 2006-11-30 14:09:44 |
Message-ID: | 456EE628.6080002@steelerubber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2006-11-30 14:10:31 | Re: Stripping kernel FreeBSD - postgres |
Previous Message | Arnaud Lesauvage | 2006-11-30 14:09:08 | Function to replace decimal value with character ? |