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. 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 http://archives.postgresql.org/pgsql-admin/2005-12/msg00266.php 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
