Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 575F137BA28 for ; Wed, 8 Oct 2008 09:31:15 -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 21398-06 for ; Wed, 8 Oct 2008 09:31:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.154]) by postgresql.org (Postfix) with ESMTP id CA7E237B9FD for ; Wed, 8 Oct 2008 09:31:10 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so2890626fgg.23 for ; Wed, 08 Oct 2008 05:31:08 -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=jN4spOHNJGfBVtd21oZVETG5ux8JLRWnp+WSurakqPU=; b=oxCZlvNg3B8b2iW51TSkCHophfu11o//+xMWQAC4O7vJgwZtGO/U1S3SEOADJxi8Tm fHVvc4+q60zxyyyuZO7zmJYXglTtI5P6F3YzDZuiCwv5rnyOxWjTPYYwSZFO+L4eznwq 6KSrkFdl0K1iR3f0FaT0svyvQjasZdubZZq5I= 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=htA2+664dVqTJtmzOt5rkiuKqHtwTiCPCeVjx1zNCIQdB8Nlr4UY0mNvSZp4CaV+s6 /UBekyq96T7HGC4b0Q0ts0EFZFe/TBYy5Q5wsmE1jT0ytgbzViboR6QshOsNvtkIiy2s TBJhRYmg9I2mnULJM2r5sWkWpG1cRE22CXVUQ= Received: by 10.86.66.19 with SMTP id o19mr7423612fga.68.1223469068790; Wed, 08 Oct 2008 05:31:08 -0700 (PDT) Received: by 10.86.71.17 with HTTP; Wed, 8 Oct 2008 05:31:08 -0700 (PDT) Message-ID: <3a0028490810080531y155edffi7ff7c68b965a834a@mail.gmail.com> Date: Wed, 8 Oct 2008 10:31:08 -0200 From: "Rafael Domiciano" To: chirag.dave@gmail.com Subject: Re: checkpoint_timeout Cc: "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4293_11506262.1223469068802" 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/46 X-Sequence-Number: 30502 ------=_Part_4293_11506262.1223469068802 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline The server is running Postgres 8.2.4When the server is doing too much operations like I, U or D the postgres stop a while each 5 min...! I mean "stopping" that I don't receive any response from postgres, and the process the all people are running stay there, waiting for something. I read a several names to it like: gap, stall, slowdown... I don't know the write expression for this situation. I hope you can help me. Thnks, Rafael Domiciano Postgres DBA 2008/10/7 > 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_4293_11506262.1223469068802 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
The server is running Postgres 8.2.4
When the server is doing too much operations like I, U or D the postgres stop a while each 5 min...!
I mean "stopping" that I don't receive any response from postgres, and the process the all people are running stay there, waiting for something.
I read a several names to it like: gap, stall, slowdown... I don't know the write expression for this situation.

I hope you can help me.

Thnks,

Rafael Domiciano
Postgres DBA

2008/10/7 <chirag.dave@gmail.com>
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_4293_11506262.1223469068802--