Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7554A37C764 for ; Thu, 9 Oct 2008 12:06:19 -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 93170-04 for ; Thu, 9 Oct 2008 12:06:05 -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 9711737BFA6 for ; Thu, 9 Oct 2008 12:06:05 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by vgateway.libertyrms.info with esmtp (Exim 4.22) id 1Knx5W-0005H9-Hh; Thu, 09 Oct 2008 11:06:02 -0400 Subject: Re: checkpoint_timeout From: Brad Nicholson To: Rafael Domiciano Cc: Scott Marlowe , Kevin Grittner , Julio Leyva , "pgsql-admin@postgresql.org" In-Reply-To: <3a0028490810090802t9294abeod6e5ece092a487e4@mail.gmail.com> References: <3a0028490810071321j32b4f450m95123d02b9fe6f49@mail.gmail.com> <3a0028490810080734r26912c72n94d6f509dfb55b6e@mail.gmail.com> <3a0028490810080919v3762f924je688a56210558e95@mail.gmail.com> <3a0028490810080934l211d137uc9dde69cad7879d9@mail.gmail.com> <48EC9D9F.EE98.0025.0@wicourts.gov> <3a0028490810081054o2100b2bci7bde6b7213712c58@mail.gmail.com> <48ECB0DD.EE98.0025.0@wicourts.gov> <3a0028490810090802t9294abeod6e5ece092a487e4@mail.gmail.com> Content-Type: text/plain; charset=utf-8 Date: Thu, 09 Oct 2008 11:06:02 -0400 Message-Id: <1223564762.6070.14.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/69 X-Sequence-Number: 30525 On Thu, 2008-10-09 at 13:02 -0200, Rafael Domiciano wrote: > Hi there. >=20 >=20 > I increased the wal_buffers and no change made. > I'm beggining to think that my problem is not related to "checkpoint & > cia" as I said early. > I have decreased the checkpoint_timeout to 3 min and the slow down > continuin' ocorring after each 5 min. >=20 >=20 > In this "slowdown" the postgres does nothing, it's simply stop doing > the operations. The softwares still waiting for the response. > This is a dedicated server, the only program another postgres that > runs is Slony-I This sounds like checkpoint issues to me. Try adjusting the bgwriter settings as suggested. --=20 =EF=BB=BFBrad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.