Date: Thu, 30 Mar 2006 15:21:46 -0500 From: Kris Kennaway <kris@obsecurity.org> To: usleepless@gmail.com Cc: Miguel <mmiranda@123.com.sv>, freebsd-questions@freebsd.org Subject: Re: terrible performance in 6.1beta4 Message-ID: <20060330202145.GA17856@xor.obsecurity.org> In-Reply-To: <c39ec84c0603301141g42f0f367i1c7669c90e1115d7@mail.gmail.com> References: <442B2FC6.9040001@123.com.sv> <20060330011834.GA84658@xor.obsecurity.org> <c39ec84c0603300047u5530fc1fjb1ba93fcafcd490d@mail.gmail.com> <442BF0BB.8010504@123.com.sv> <c39ec84c0603301141g42f0f367i1c7669c90e1115d7@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060330202145.GA17856>