From: Corey.Brune@transplace.com
To: pginfo <pginfo@t1.unisoftbg.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-admin-owner@postgresql.org
Subject: Re: freebsd performance
Date: Mon, 3 May 2004 09:37:33 -0500
Message-ID: <OF37D41C80.DA2B491E-ON86256E89.004F7294@transplace.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Corey.Brune@transplace.com, pginfo@t1.unisoftbg.com, pgsql-admin-owner@postgresql.org
Subject: Re: freebsd performance
In-Reply-To: <OF37D41C80.DA2B491E-ON86256E89.004F7294@transplace.com>
References: <OF37D41C80.DA2B491E-ON86256E89.004F7294@transplace.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox