Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 4856A37C12D
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  7 Oct 2008 18:13:43 -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 26107-01 for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  7 Oct 2008 18:13:40 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.226])
	by postgresql.org (Postfix) with ESMTP id 1978F37BAD7
	for <pgsql-admin@postgresql.org>; Tue,  7 Oct 2008 18:13:39 -0300 (ADT)
Received: by rv-out-0506.google.com with SMTP id b25so3552253rvf.43
	for <pgsql-admin@postgresql.org>; Tue, 07 Oct 2008 14:13:38 -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:cc:in-reply-to:mime-version:content-type:references;
	bh=G40HZilDwXgbj4LunRoQQqd9zWqVmjqCTzIhFA7cCkY=;
	b=YuZNQ3fzxIRj63wsn0qRjqinw5UTY/dQdCr/iHdskWfw7Nf0jImY0jJBLad8qmxjlF
	0xtlLUY3fjVuT6jZoPL8TDxavskjGUFkiGf2ISKqdYQSofM75BuT2y1LmaCFErJkeHis
	yD8EgtBjAcW37E6N2hrFtxLfve82GHnfkLIQs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:references;
	b=q8QEEtNYub842tw9tqtOwDXuaOH3wkcWFum3DcuTkAEMwe3IAQvLsWRi6eYUizEgoL
	SSsXOH4dWcOk9/1nrykOgJTt2/0Tq8xajNnspUw/fUuJjBNWTbj9oINOQ7WYXltyOqjS
	HTUdUPK8x9PH6N3NjyY5aDcXY4eQmmFWYTyJY=
Received: by 10.141.23.7 with SMTP id a7mr4304641rvj.5.1223414018588;
	Tue, 07 Oct 2008 14:13:38 -0700 (PDT)
Received: by 10.141.43.10 with HTTP; Tue, 7 Oct 2008 14:13:38 -0700 (PDT)
Message-ID: <f1d4f3170810071413l3bb62167n2fa32a8ab1ec6dc@mail.gmail.com>
Date: Tue, 7 Oct 2008 17:13:38 -0400
From: chirag.dave@gmail.com
To: "Rafael Domiciano" <rafael.domiciano@gmail.com>
Subject: Re: checkpoint_timeout
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <3a0028490810071321j32b4f450m95123d02b9fe6f49@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_48145_14768962.1223414018588"
References: <3a0028490810071321j32b4f450m95123d02b9fe6f49@mail.gmail.com>
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/43
X-Sequence-Number: 30499

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

What version of postgres are you running ?  and please also provide more
information about your suspected slowdown ?




On Tue, Oct 7, 2008 at 4:21 PM, Rafael Domiciano <rafael.domiciano@gmail.com
> wrote:

> 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_48145_14768962.1223414018588
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">What version of postgres are you running ?&nbsp; and please also provide more information about your suspected slowdown ?<br><br><br><br><br><div class="gmail_quote">On Tue, Oct 7, 2008 at 4:21 PM, Rafael Domiciano <span dir="ltr">&lt;<a href="mailto:rafael.domiciano@gmail.com" target="_blank">rafael.domiciano@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><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><font color="#888888"><div>Rafael Domiciano</div>

</font></div>
</div>
</blockquote></div><br></div>

------=_Part_48145_14768962.1223414018588--