Re: High I/O writes activity on disks causing images on browser to lag and not load
От | Jennifer Trey |
---|---|
Тема | Re: High I/O writes activity on disks causing images on browser to lag and not load |
Дата | |
Msg-id | 863606ec0906031534r3e78c8f1q4995e8c0edd18b0c@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: High I/O writes activity on disks causing images on browser to lag and not load (Bill Moran <wmoran@potentialtech.com>) |
Ответы |
Re: High I/O writes activity on disks causing images on
browser to lag and not load
|
Список | pgsql-general |
The research is based on hypotheses and assumptions which in the end can be discarded or not. I do not know these things, I am taking one step at time, learning and trying.
Thanks / Jennifer
I don't understand what kind of research you want me to do. I don't have any performance problem other than that images seems to get stuck on occasion, with a certain amount of users.This is what I've got, and I have spent several weeks reaching this stage. I started by removing a router and arranging another internet, benchmarking the application, study the network card, switching to Apache Server and I have ruled all of them out. I have now come to the disk, and here its postgre thats most active and its starting to feel right, but I could be wrong but what other leads do I have?
Since even a select count(*) outside my application is causing this I do not understand what conclusion I should take. After all, you said it yourself, you do not get any writes, why do I ? With perfmon under heavy load I registered 4000 I/0 transefers / sec and they where all writes so I think I am getting closer.
Here is a similar one but on linux
I am will try turn the stats off, but I am not sure how that might affect the db's internal stats on how to best run a query, what indices is good or not.. ?
Thanks / Jennifer
В списке pgsql-general по дате отправления: