Re: Write workload is causing severe slowdown in Production - Mailing list pgsql-performance

From Gnanakumar
Subject Re: Write workload is causing severe slowdown in Production
Date
Msg-id 00bd01cd0828$accc8110$06658330$@com
Whole thread Raw
In response to Re: Write workload is causing severe slowdown in Production  ("Gnanakumar" <gnanam@zoniac.com>)
Responses Re: Write workload is causing severe slowdown in Production  ("Tomas Vondra" <tv@fuzzy.cz>)
List 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 by date:

Previous
From: "Gnanakumar"
Date:
Subject: Re: Write workload is causing severe slowdown in Production
Next
From: "Tomas Vondra"
Date:
Subject: Re: Write workload is causing severe slowdown in Production