Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: "'Tomas Vondra'" <tv@fuzzy.cz>
Cc: "'Vitalii Tymchyshyn'" <tivv00@gmail.com>,
	<pgsql-performance@postgresql.org>
References: <006301cd07fd$358ebe40$a0ac3ac0$@com> <4F6AF3FE.30407@gmail.com>
	<dc1f59dfd626334d6f37d5a6ffb97bb9.squirrel@sq.gransy.com>
	<008e01cd0817$06418680$12c49380$@com>
	<1bbfac04d1ec4a2708e47593dc84ba8c.squirrel@sq.gransy.com>
	<00b601cd0824$c8dfd6d0$5a9f8470$@com>
In-Reply-To: <00b601cd0824$c8dfd6d0$5a9f8470$@com>
Subject: Re: Write workload is causing severe slowdown in Production
Date: Thu, 22 Mar 2012 18:08:18 +0530
Organization: Zoniac Software Private Limited
Message-ID: <00bd01cd0828$accc8110$06658330$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: Ac0IGJQRxpVW+ByNQByMQHjEErYfCwACyOeQAADsUhA=
Content-Language: en-us

> 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?