terrible performance in 6.1beta4

[Kris Kennaway]

On Thu, Mar 30, 2006 at 08:52:43AM -0600, Miguel wrote:
> usleepless at 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

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20060330/9e9f0f27/attachment.pgp