On 22 Březen 2012, 13:10, Gnanakumar wrote: >> So, what else is running on the system? Because if there's 35GB RAM and >> the shared buffers are 1.5GB, then there's about 33GB for page cache. >> Something like 16GB would be a conservative setting. > > Yes, you guessed it right. Both Web server and DB server are running in > the same machine. > >> I'm not saying this will fix the issues, but maybe it shows that >> something >> else is running on the box and maybe that's the culprit, not PostgreSQL? > > Based on my observations and analysis, I'm sure that database write > operation "is" causing the slowdown, but not because of other applications > running in the same server. You haven't provided any clear evidence for such statement so far. Let's wait for the vmstat/iostat logs etc. Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
