Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 31E9837BCA1 for ; Wed, 8 Oct 2008 11:23:09 -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 48274-05 for ; Wed, 8 Oct 2008 11:23:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vgateway.libertyrms.info (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 05C8B37BA5B for ; Wed, 8 Oct 2008 11:23:02 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by vgateway.libertyrms.info with esmtp (Exim 4.22) id 1KnZwK-0005GP-6w; Wed, 08 Oct 2008 10:23:00 -0400 Subject: Re: checkpoint_timeout From: Brad Nicholson To: Rafael Domiciano Cc: chirag.dave@gmail.com, "pgsql-admin@postgresql.org" In-Reply-To: <3a0028490810080531y155edffi7ff7c68b965a834a@mail.gmail.com> References: <3a0028490810071321j32b4f450m95123d02b9fe6f49@mail.gmail.com> <3a0028490810080531y155edffi7ff7c68b965a834a@mail.gmail.com> Content-Type: text/plain; charset=utf-8 Date: Wed, 08 Oct 2008 10:23:00 -0400 Message-Id: <1223475780.6070.10.camel@bnicholson-desktop> Mime-Version: 1.0 X-Mailer: Evolution 2.22.3.1 Content-Transfer-Encoding: quoted-printable X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200810/49 X-Sequence-Number: 30505 On Wed, 2008-10-08 at 10:31 -0200, Rafael Domiciano wrote: > 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. The bgwriter was added to help alleviate this problem. What are your settings for that? The solution may be to push dirty buffers to disk more aggressively via the bgwriter so you have less work to do at checkpoint time. --=20 =EF=BB=BFBrad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.