Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 30 Mar 2006 10:47:56 +0200
From:      usleepless@gmail.com
To:        Miguel <mmiranda@123.com.sv>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: terrible performance in 6.1beta4
Message-ID:  <c39ec84c0603300047u5530fc1fjb1ba93fcafcd490d@mail.gmail.com>
In-Reply-To: <20060330011834.GA84658@xor.obsecurity.org>
References:  <442B2FC6.9040001@123.com.sv> <20060330011834.GA84658@xor.obsecurity.org>

next in thread | previous in thread | raw e-mail | index | archive | help
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, an=
d
> > 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...

how big is the file?

regards,

usleep



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?c39ec84c0603300047u5530fc1fjb1ba93fcafcd490d>