Re: Checkpoint_segments optimal value

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