Re: Checkpoint_segments optimal value
От | John R Pierce |
---|---|
Тема | Re: Checkpoint_segments optimal value |
Дата | |
Msg-id | 53CD8048.4010002@hogranch.com обсуждение исходный текст |
Ответ на | Re: Checkpoint_segments optimal value (Kevin Grittner <kgrittn@ymail.com>) |
Ответы |
Re: Checkpoint_segments optimal value
|
Список | pgsql-general |
On 7/21/2014 1:51 PM, Kevin Grittner wrote: > The above might help, but I think the biggest problem may be your > VM. You show very low disk I/O numbers, but a pretty significant > fraction of the time waiting for I/O. The previously-suggested > iostat output may help nail it down more specifically, but > basically you seem to have a big problem with bandwidth for storage > access. It's pretty disturbing to see lines in vmstat output which > show zero disk in or out, but over 10% of CPU time waiting for > storage?!? that would suggest to me a large number of VMs sharing a single SATA drive, or similar. -- john r pierce 37N 122W somewhere on the middle of the left coast
В списке pgsql-general по дате отправления: