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