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
<pginfo@t1.unisoftbg. To: pgsql-admin@postgresql.org
com> cc:
Sent by: Subject: [ADMIN] freebsd performance
pgsql-admin-owner@pos
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