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