terrible performance in 6.1beta4

[Kris Kennaway]

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
-------------- 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/53d8a263/attachment.pgp