| From: | "Gnanakumar" <gnanam(at)zoniac(dot)com> |
|---|---|
| To: | "'Tomas Vondra'" <tv(at)fuzzy(dot)cz> |
| Cc: | "'Vitalii Tymchyshyn'" <tivv00(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Write workload is causing severe slowdown in Production |
| Date: | 2012-03-22 12:38:18 |
| Message-ID: | 00bd01cd0828$accc8110$06658330$@com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 together than 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 reading the description from above doc, am not able to get this point clearly. Can you help me in understanding this?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2012-03-22 12:52:39 | Re: Write workload is causing severe slowdown in Production |
| Previous Message | Gnanakumar | 2012-03-22 12:10:29 | Re: Write workload is causing severe slowdown in Production |