X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4FD3ED1EF4A; Mon, 3 May 2004 11:37:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95380-01; Mon, 3 May 2004 11:37:33 -0300 (ADT) Received: from psplotp1.transplace.com (mail.transplace.com [65.64.216.31]) by svr1.postgresql.org (Postfix) with ESMTP id 86904D1EF09; Mon, 3 May 2004 11:37:29 -0300 (ADT) Subject: Re: freebsd performance To: pginfo Cc: pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-ID: From: Corey.Brune@transplace.com Date: Mon, 3 May 2004 09:37:33 -0500 X-MIMETrack: Serialize by Router on psplotp1/com(Release 5.0.11 |July 24, 2002) at 05/03/2004 09:37:34 AM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200405/7 X-Sequence-Number: 13323 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 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