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 > 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, and > 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:
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
pgpw10aIVmmuU.pgp
Description: PGP signature
