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