| From: | Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Not a PG question: SCSI question |
| Date: | 2001-05-15 14:17:22 |
| Message-ID: | 4.3.1.20010515160831.02f0b660@mail.eurovox.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ryan Mahoney | 2001-05-15 14:48:39 | Re: Performance aggregates |
| Previous Message | Tom Lane | 2001-05-15 14:05:02 | Re: Re: naming convention/mixed case |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-05-15 14:34:51 | Re: pg_index.isclustered can work |
| Previous Message | Bruce Momjian | 2001-05-15 14:14:43 | Re: please apply patch for GiST (7.1.1, current cvs) |