Not a PG question: SCSI question - Mailing list pgsql-general

From Jean-Arthur Silve
Subject Not a PG question: SCSI question
Date
Msg-id 4.3.1.20010515160831.02f0b660@mail.eurovox.fr
Whole thread Raw
In response to Re: Re: Internet is putting lot of competition fire & heat under Microsoft SQL Server  (Justin Clift <justin@postgresql.org>)
List pgsql-general
Hi !

I have 2 servers running apache, php and PG 7.0.3 running under Linux

The first one uses IDE disks, and everything run fine and fast. (uses linux
2.0.36)

The second one uses SCSI drives with a Adaptec adapter. (uses Linux 2.2.14)

My problem is that acces to the DB on this server are very very slow (I
guess that it s particulary slow when i do INSERTs)
It s so slow that even the keyboard and the display slow down ! The HD
write or read a lot...
When I do a "ps" or "top", I don't see any process taking all the ressources...

So, I guess there is something whith the SCSI...

Is anybody has a clue ??

thanks !

jean-arthur
PS : I did a vacuum analyze, and the table are not so big (max tuples are
5000 )

----------------------------------------------------------------
EuroVox
4, place Félix Eboue
75583 Paris Cedex 12
Tel : 01 44 67 05 05
Fax : 01 44 67 05 19
Web : http://www.eurovox.fr
----------------------------------------------------------------


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Wal logs continued...
Next
From: "Thomas F. O'Connell"
Date:
Subject: locking a dropped table