From owner-freebsd-questions@FreeBSD.ORG Thu Mar 30 14:38:41 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 58C2916A424 for ; Thu, 30 Mar 2006 14:38:41 +0000 (UTC) (envelope-from mmiranda@123.com.sv) Received: from asgard1.americatelsal.com (asgard.americatelsal.com [200.13.161.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id 016F643D68 for ; Thu, 30 Mar 2006 14:38:33 +0000 (GMT) (envelope-from mmiranda@123.com.sv) Received: (qmail 45114 invoked from network); 30 Mar 2006 15:00:46 -0000 Received: from unknown (HELO ?192.168.10.124?) (200.13.161.68) by asgard1.americatelsal.com with SMTP; 30 Mar 2006 15:00:46 -0000 Message-ID: <442BEE4B.1070401@123.com.sv> Date: Thu, 30 Mar 2006 08:42:19 -0600 From: Miguel User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kris Kennaway References: <442B2FC6.9040001@123.com.sv> <20060330011834.GA84658@xor.obsecurity.org> In-Reply-To: <20060330011834.GA84658@xor.obsecurity.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: terrible performance in 6.1beta4 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 30 Mar 2006 14:38:41 -0000 Kris Kennaway wrote: >On Wed, Mar 29, 2006 at 07:09:26PM -0600, Miguel wrote: > > >>Hi, im loading a lot of information to a postgresql 8.1.3 database, im >>using the copy command, using the same file and version of postgres in >>gentoo it spend a few minutes (~4-5), in freebsd 6.1-beta4 it has >>already spent 25 minutes and the server apparently is doing nothing, and >>the reponse time of remote logins or running simple commands like ls -l >>/etc takes a lot of time (35 secs ort so), cpu usage is very low: >> >> > >It's spending all its time reading from disk. What else is different >between your two systems (hardware, database configuration)? > > This is a brand new server, with sata controller, 250G disks without array, the old one has a hp 5i controller, 6 x 70G 10k 320 scsi disks. --- Miguel