From owner-freebsd-questions@FreeBSD.ORG Thu Mar 30 01:18:35 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 AB4E916A400 for ; Thu, 30 Mar 2006 01:18:35 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from elvis.mu.org (elvis.mu.org [192.203.228.196]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6DB5C43D46 for ; Thu, 30 Mar 2006 01:18:35 +0000 (GMT) (envelope-from kris@obsecurity.org) Received: from obsecurity.dyndns.org (elvis.mu.org [192.203.228.196]) by elvis.mu.org (Postfix) with ESMTP id 540401A4DEB; Wed, 29 Mar 2006 17:18:35 -0800 (PST) Received: by obsecurity.dyndns.org (Postfix, from userid 1000) id 7AA8054817; Wed, 29 Mar 2006 20:18:34 -0500 (EST) Date: Wed, 29 Mar 2006 20:18:34 -0500 From: Kris Kennaway To: Miguel Message-ID: <20060330011834.GA84658@xor.obsecurity.org> References: <442B2FC6.9040001@123.com.sv> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="UugvWAfsgieZRqgk" Content-Disposition: inline In-Reply-To: <442B2FC6.9040001@123.com.sv> User-Agent: Mutt/1.4.2.1i 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 01:18:35 -0000 --UugvWAfsgieZRqgk Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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=20 > using the copy command, using the same file and version of postgres in=20 > gentoo it spend a few minutes (~4-5), in freebsd 6.1-beta4 it has=20 > already spent 25 minutes and the server apparently is doing nothing, and= =20 > the reponse time of remote logins or running simple commands like ls -l= =20 > /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)? > 10671 postgres 1 -8 0 538M 516M biord 1 0:46 8.98% postgres > 10384 postgres 1 -8 0 538M 528M biord 0 3:23 0.00% postgres > 8862 postgres 1 -4 0 537M 524M ufs 1 1:10 0.00% postgres Kris --UugvWAfsgieZRqgk Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (FreeBSD) iD8DBQFEKzHpWry0BWjoQKURAtaaAJ9Id6Ks+zoEh0Rqo2+4dTaiBicpUACg6nOA ZIguoNmD4tTURTGAxn6XLRo= =zKVk -----END PGP SIGNATURE----- --UugvWAfsgieZRqgk--