Re: long checkpoint_timeout
От | Jeff Davis |
---|---|
Тема | Re: long checkpoint_timeout |
Дата | |
Msg-id | 1172262188.10824.248.camel@dogma.v10.wvs обсуждение исходный текст |
Ответ на | Re: long checkpoint_timeout ("Jim C. Nasby" <jim@nasby.net>) |
Ответы |
Re: long checkpoint_timeout
|
Список | pgsql-performance |
On Fri, 2007-02-23 at 14:02 -0600, Jim C. Nasby wrote: > > say that checkpoints cause extra disk I/O. Is there a good way to > > measure how much extra I/O (and WAL volume) is caused by the > > checkpoints? Also, it would be good to know how much total I/O is caused > > by a checkpoint so that I know if bgwriter is doing it's job. > > There's a patch someone just came up with that provides additional debug > info about both bgwriter operation and checkpoints. I know it will at > least tell you how much was written out by a checkpoint. Excellent, that would answer a lot of my questions. I did some brief searching and nothing turned up. Do you have a link to the discussion or the patch? Regards, Jeff Davis
В списке pgsql-performance по дате отправления: