Re: freebsd performance

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