Date: Thu, 30 Mar 2006 08:52:43 -0600 From: Miguel <mmiranda@123.com.sv> To: usleepless@gmail.com Cc: freebsd-questions@freebsd.org Subject: Re: terrible performance in 6.1beta4 Message-ID: <442BF0BB.8010504@123.com.sv> In-Reply-To: <c39ec84c0603300047u5530fc1fjb1ba93fcafcd490d@mail.gmail.com> References: <442B2FC6.9040001@123.com.sv> <20060330011834.GA84658@xor.obsecurity.org> <c39ec84c0603300047u5530fc1fjb1ba93fcafcd490d@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
usleepless@gmail.com wrote: >Miguel, > > > >>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: >>> >>> > >how do your postgresql.conf's compare? things like shared buffers, fsync... > > > the only diference is in shared_buffers, the new one has only 2G of ram, while the old one 3G, both has fsync = on (the default value) >how big is the file? > > 3.0G > > --- Miguel
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?442BF0BB.8010504>