pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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








view thread (3+ messages)

Message-ID: <OF37D41C80.DA2B491E-ON86256E89.004F7294@transplace.com>
Permalink:  ../OF37D41C80.DA2B491E-ON86256E89.004F7294@transplace.com/
Also on:    postgresql.org/message-id/OF37D41C80.DA2B491E-ON86256E89.004F7294@transplace.com

 · 

reply

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