| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Checkpoint_segments optimal value |
| Date: | 2014-07-18 01:11:41 |
| Message-ID: | 53C8744D.8030506@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ferrell, Denise CTR NSWCDD, Z11 | 2014-07-18 16:56:08 | [ADMIN] Editable Views |
| Previous Message | Prabhjot Sheena | 2014-07-18 00:36:36 | Re: Checkpoint_segments optimal value |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wd | 2014-07-18 02:01:50 | Re: Detect streaming replication failure |
| Previous Message | Prabhjot Sheena | 2014-07-18 00:36:36 | Re: Checkpoint_segments optimal value |