From: Tomas Vondra <tv@fuzzy.cz>
To: gnanam@zoniac.com
Cc: 'Tomas Vondra' <tv@fuzzy.cz>
Cc: 'Vitalii Tymchyshyn' <tivv00@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Write workload is causing severe slowdown in Production
Date: Thu, 22 Mar 2012 13:52:39 +0100
Message-ID: <6fa153b454f30dd989039af7695d9fe7.squirrel@sq.gransy.com> (raw)
In-Reply-To: <00bd01cd0828$accc8110$06658330$@com>
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>
<00bd01cd0828$accc8110$06658330$@com>
On 22 Březen 2012, 13:38, Gnanakumar wrote:
>> 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?
A checkpoint may be triggered for two main reasons:
(1) all available WAL segments are filled (you do have 32 of them, i.e.
512MB of WAL data)
(2) the checkpoint_timeout runs out (by default 5 mins IIRC)
The checkpoint_warning should emmit a 'warning' message whenever the
checkpoint happens less than the specified number of seconds since the
last one, so setting it high enough should log all checkpoints.
The fact that this does not happen (no warning messages) suggests this is
not caused by checkpoints. It may be caused by the database, but it seems
unlikely it's checkpoints.
Tomas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz, gnanam@zoniac.com, tivv00@gmail.com
Subject: Re: Write workload is causing severe slowdown in Production
In-Reply-To: <6fa153b454f30dd989039af7695d9fe7.squirrel@sq.gransy.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox