On 7/17/2014 5:36 PM, Prabhjot Sheena wrote:
The overall load of system is good. It is a vm but the other database is running normal and not doing much activity
other database? is that on the same postgresql cluster? or on a seperate instance of the postgres server on the same VM? or on a seperate VM on the same host ?
what does `iostat -x 5` show ? let it run a bunch of samples, then run this slow query and get more samples. pay attention to the disk drive(s) the database is stored on.
high %utilization or await times would be a bad thing. -- john r pierce 37N 122W somewhere on the middle of the left coast
