Re: Write workload is causing severe slowdown in Production
| От | Gnanakumar |
|---|---|
| Тема | Re: Write workload is causing severe slowdown in Production |
| Дата | |
| Msg-id | 00bd01cd0828$accc8110$06658330$@com обсуждение исходный текст |
| Ответ на | Re: Write workload is causing severe slowdown in Production ("Gnanakumar" <gnanam@zoniac.com>) |
| Ответы |
Re: Write workload is causing severe slowdown in
Production
|
| Список | pgsql-performance |
> There's a checkpoint_warning option. Set it to 3600 and you should get messages in the log. I've a basic question about setting "checkpoint_warning" configuration. 8.2 doc (http://www.postgresql.org/docs/8.2/interactive/runtime-config-wal.html)says: "Write a message to the server log if checkpoints caused by the filling of checkpoint segment files happen closer togetherthan this many seconds (which suggests that checkpoint_segments ought to be raised). The default is 30 seconds (30s)." How does increasing the default 30s to 3600s (which is 1 hour or 60 minutes) print messages to the log? Even after readingthe description from above doc, am not able to get this point clearly. Can you help me in understanding this?
В списке pgsql-performance по дате отправления: