From owner-freebsd-questions@FreeBSD.ORG Thu Mar 30 20:21:47 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 6166516A422 for ; Thu, 30 Mar 2006 20:21:47 +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 188EA43D5D for ; Thu, 30 Mar 2006 20:21:47 +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 E7B151A4DAB; Thu, 30 Mar 2006 12:21:46 -0800 (PST) Received: by obsecurity.dyndns.org (Postfix, from userid 1000) id 328CF515BF; Thu, 30 Mar 2006 15:21:46 -0500 (EST) Date: Thu, 30 Mar 2006 15:21:46 -0500 From: Kris Kennaway To: usleepless@gmail.com Message-ID: <20060330202145.GA17856@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="liOOAslEiF7prFVr" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i Cc: Miguel , 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 20:21:47 -0000 --liOOAslEiF7prFVr Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Mar 30, 2006 at 09:41:51PM +0200, usleepless@gmail.com wrote: > Miguel, >=20 > > 3.0G >=20 > i looked at your top-screenshot, i have the impression you could > dedicate far more memory to postgresql. maybe it would be usefull to > post your postgresql.conf ( this is in fact a postgresql question, but > i don't care ). >=20 > you might want to turn fsync off, my limited knowledge about this > switch tells me it is only important in case of powerfailures. >=20 > you want to give postgresql as much memory as it needs, cause else it > will underperform heavily. this might be one of the reasons it is not > catching on as quick as i would like. postgresql is the best in OSS > though. Yes, this is my impression of the problem too. Any time your process is waiting on disk I/O it is going to perform terribly (on any OS - disks are slow), and the way to fix this is to make sure it does as little I/O as possible (by allowing everything to be cached in RAM). Kris --liOOAslEiF7prFVr Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (FreeBSD) iD8DBQFELD3ZWry0BWjoQKURArl2AKCSZDi2aYOKfQ12Fv/f//F/XDglXQCgswZ3 fKDEvI/gjVVF9jIskuILG7s= =3Pkc -----END PGP SIGNATURE----- --liOOAslEiF7prFVr--