Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 3110337C272
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  7 Oct 2008 17:21:55 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 13044-04 for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  7 Oct 2008 17:21:49 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175])
	by postgresql.org (Postfix) with ESMTP id 6EA9437C250
	for <pgsql-admin@postgresql.org>; Tue,  7 Oct 2008 17:21:49 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id 29so360404ugo.7
	for <pgsql-admin@postgresql.org>; Tue, 07 Oct 2008 13:21:47 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=AZzQCOrFW5wo33EE9vIsa3ZAGTsIqPHCfiwQ8qu/6YI=;
	b=ndVxIvTzK9nEv9kCLO3ss9HoIpaceFHEEKK/xjD1wZ/TpzIu27xgw4xUEL2n7Fq4zW
	gqcfFej6cY4kKLfaPTlORYCNwT9OvoErIeSdQJqD8p8RX1YObHTVJEytZ607oAwEVoXr
	lQWuPXRhfUMYNmxplBiu/7PUGLBvg4sQJMVaA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=UZEyZ8Yaf74Fk1DMhN+UsNLXh3muwgA7qLRzVvXNR8hdbkHXuNleVR2XRzTDw3WMTt
	ycZ4PMKCsu502ixTqvKpD0B0CrbHuj2oqnlZoe/yUfnVSWAG/1/LZIzgZ6S+fJ2PTewo
	VPK1juAzs6A/M/PULR6SA6kwWxjnLL+99j3VQ=
Received: by 10.86.71.1 with SMTP id t1mr6646628fga.36.1223410907518;
	Tue, 07 Oct 2008 13:21:47 -0700 (PDT)
Received: by 10.86.71.17 with HTTP; Tue, 7 Oct 2008 13:21:47 -0700 (PDT)
Message-ID: <3a0028490810071321j32b4f450m95123d02b9fe6f49@mail.gmail.com>
Date: Tue, 7 Oct 2008 18:21:47 -0200
From: "Rafael Domiciano" <rafael.domiciano@gmail.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: checkpoint_timeout
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1875_20318864.1223410907503"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200810/42
X-Sequence-Number: 30498

------=_Part_1875_20318864.1223410907503
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello there,
I'm having some slowndowns in my postgresql server, and I had been reading
something about checkpoints, that could resolve my problem.
Now, I have:
checkpoint_segments = 30                # in logfile segments, min 1, 16MB
each
#checkpoint_timeout = 5min

And I percebed that this slowndown is occuring for 5 min...! So I'm suposing
that the problem is in the checkpoint_timeout.

What's the impact to chang it to:
checkpoint_timeout = 2min or
checkpoint_timeout = 5min

Tnhks,

Rafael Domiciano

------=_Part_1875_20318864.1223410907503
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Hello there,<div><br></div><div>I&#39;m having some slowndowns in my postgresql server, and I had been reading something about checkpoints, that could resolve my problem.</div><div>Now, I have:</div><div><div>
checkpoint_segments = 30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;# in logfile segments, min 1, 16MB each</div><div>#checkpoint_timeout = 5min&nbsp;</div><div><br></div><div>And I percebed that this slowndown is occuring for 5 min...! So I&#39;m suposing that the problem is in the checkpoint_timeout.</div>
<div><br></div><div>What&#39;s the impact to chang it to:</div><div>checkpoint_timeout = 2min or</div><div>checkpoint_timeout = 5min<br></div><div><br></div><div>Tnhks,</div><div><br></div><div>Rafael Domiciano</div></div>
</div>

------=_Part_1875_20318864.1223410907503--