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  ("Tomas Vondra" <tv@fuzzy.cz>)
Список 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 по дате отправления:

Предыдущее
От: "Gnanakumar"
Дата:
Сообщение: Re: Write workload is causing severe slowdown in Production
Следующее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Write workload is causing severe slowdown in Production