From owner-freebsd-questions@FreeBSD.ORG Thu Mar 30 15:01:38 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 097FA16A425 for ; Thu, 30 Mar 2006 15:01:38 +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 B9D1043D49 for ; Thu, 30 Mar 2006 15:01:37 +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 A09641A4D81; Thu, 30 Mar 2006 07:01:37 -0800 (PST) Received: by obsecurity.dyndns.org (Postfix, from userid 1000) id 0F7D151F4D; Thu, 30 Mar 2006 10:01:37 -0500 (EST) Date: Thu, 30 Mar 2006 10:01:36 -0500 From: Kris Kennaway To: Miguel Message-ID: <20060330150136.GA12982@xor.obsecurity.org> References: <442B2FC6.9040001@123.com.sv> <20060330011834.GA84658@xor.obsecurity.org> <442BF0BB.8010504@123.com.sv> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="y0ulUmNC+osPPQO6" Content-Disposition: inline In-Reply-To: <442BF0BB.8010504@123.com.sv> User-Agent: Mutt/1.4.2.1i Cc: freebsd-questions@freebsd.org, usleepless@gmail.com 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 15:01:38 -0000 --y0ulUmNC+osPPQO6 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Mar 30, 2006 at 08:52:43AM -0600, Miguel wrote: > usleepless@gmail.com wrote: >=20 > >Miguel, > > > >=20 > > > >>On Wed, Mar 29, 2006 at 07:09:26PM -0600, Miguel wrote: > >> =20 > >> > >>>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, a= nd > >>>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: > >>> =20 > >>> > > > >how do your postgresql.conf's compare? things like shared buffers, fsync= ... > > > >=20 > > > the only diference is in shared_buffers, the new one has only 2G of ram,= =20 > while the old one 3G, both has fsync =3D on (the default value) >=20 > >how big is the file? > >=20 > > > 3.0G Well there you go then..you're trying to access a file that is larger than RAM, so naturally you won't be able to fit it all in RAM, and with 1GB less RAM in your system you'll spend much more time reading bits of it from disk and later throwing them away. Kris --y0ulUmNC+osPPQO6 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (FreeBSD) iD8DBQFEK/LQWry0BWjoQKURAicIAKDy1NJh3+lnrAr3ISVJunZjV/cDowCgprNk uNTpShAixTh08fYsME3sVrM= =MkW+ -----END PGP SIGNATURE----- --y0ulUmNC+osPPQO6--