Try looking at your kernel- make sure that you don't have any debugging turned on, and comment out all unnecessary devices. Read the man page on tuning.
What is slow? Are any metrics at 100%, i.e. IO or CPU? If you need more help, please provide additional information. Corey pginfo <[EMAIL PROTECTED] To: [EMAIL PROTECTED] com> cc: Sent by: Subject: [ADMIN] freebsd performance [EMAIL PROTECTED] tgresql.org 05/02/2004 03:41 AM Hi all, I try to find OS with better performance. At the mement we are using linux RH AS 3.0 and I think it is not the best possible. So my test server: Dual Pentium III 1 GHz 1.5 GB ram 30 GB ATA 7200 HDD. pg 7.4.2 I installed freebsd 5.2.1 (It is my first try on it). and ran the same db and pg setup. So I see 30% slower freebsd box compared to linux RH. My question: exists any special setups into freebsd to get it running faster? Also any good docs about configuring freebsd for postgresql will helpfull . regards, ivan. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 3: 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