Re: [GENERAL] Stripping kernel FreeBSD - postgres
On Nov 30, 2006, at 8:50 AM, Enrico wrote: I already read your link and it is not specific for Postgres, I'm searching for a more specific document. Just remove any devices you don't have on your machine, and remove any "extras" like linux compat, older version compat, etc. You probably also want to disable kernel module loading (and not build any modules). ... but the kernel is demand paged so it won't really load up the code that's not used. Personally I have a pseudo-custom configuration that covers all of my various machines and removes devices and modules I don't need. I load up USB on computers that have only USB keyboards as a module for example. You should spend more time tuning postgres itself. smime.p7s Description: S/MIME cryptographic signature
Re: [GENERAL] Stripping kernel FreeBSD - postgres
> > 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. Done > FreeBSD 6.1 is pretty optimized already, and it will adapt. Have you followed > the directions for building a custom kernel? Yes. > 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). Done > 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 > Ok Thanks a lot Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look, he already is [EMAIL PROTECTED] - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Stripping kernel FreeBSD - postgres
Bill Moran wrote: In response to Enrico <[EMAIL PROTECTED]>: HI, I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres installed. Where can I have any info about? http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/kernelconfig.html It appears as if English is not your primary language, is it Italian? The FreeBSD handbook has been translated to Italian if that will make things easier for you: http://www.freebsd.org/doc/it_IT.ISO8859-15/books/handbook/kernelconfig.html Also something more PostgreSQL specific - http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html http://lists.freebsd.org/pipermail/freebsd-performance/2004-January/000634.html -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] 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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] 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 [EMAIL PROTECTED] 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 // ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Stripping kernel FreeBSD - postgres
> 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. Regards, Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look, he already is [EMAIL PROTECTED] - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Stripping kernel FreeBSD - postgres
In response to Enrico <[EMAIL PROTECTED]>: > HI, > I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres > installed. > Where can I have any info about? http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/kernelconfig.html It appears as if English is not your primary language, is it Italian? The FreeBSD handbook has been translated to Italian if that will make things easier for you: http://www.freebsd.org/doc/it_IT.ISO8859-15/books/handbook/kernelconfig.html -- Bill Moran Collaborative Fusion Inc. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] Stripping kernel FreeBSD - postgres
HI, I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres installed. Where can I have any info about? Thanks in advantage. Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look, he already is [EMAIL PROTECTED] - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
