Re: High I/O writes activity on disks causing images on browser to lag and not load

[Jennifer Trey <jennifer.trey@xxxxxxxxx>]

I accidentally replied only to Grzegorz before so I don't think it turned up on the mailing list. Here it is again. (Bill, I will try to answer your email in a minute)

---

Thank you for you answer :)

2009/6/3 Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>

move postgresql to another disc if possible.

 

I have 2 disks thats the best Samsung has to offer :

http://www.samsung.com/global/business/hdd/productType.do?group=72# (HE103UJ, at the bottom of page)

First splitted on

C:100GB ( Windows Server drive with postgreSQL installation )

E: 800GB with PostgreSQL data.

I: Pictures

Do you suggest that I move the  PostgreSQL data to another disk or all of it? Including the installation?

You have really slow
discs if that happen,

 

By that you mean, that writes occur if one has to slow disks?

 

or perhaps it does loads of seq scans, because
of lack of indices.

 

Its possible that its the lack of indices, but they are pretty many. Most of the fetching thats being done is through a primary key. However when using search, there is a1-2 JOINS in each search. Does perhaps a JOIN force a writing to the disk?

All in all, it seems like your server is to low spec for what you are
trying to do.

 

Not sure about that Grzegorz, its a pretty powerful computer :) and I don't have that much data and traffic yet.. 

Normally, should the writes really be more than the reads?

Intel Quad Core 2.4 GHz
8GB Memory
Asus P5B Motherboard (Standard Version)
Windows Web Server 2008 x64 (trial)
PostgreSQL 32bit
Application running Java x64 and on Jetty Server 6
2 Samung Disks...

Thanks / Jennifer