pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Brad Nicholson <bnichols@ca.afilias.info>
To: Rafael Domiciano <rafael.domiciano@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Julio Leyva <jcleyva@hotmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: checkpoint_timeout
Date: Thu, 09 Oct 2008 11:06:02 -0400
Message-ID: <1223564762.6070.14.camel@bnicholson-desktop> (raw)
In-Reply-To: <3a0028490810090802t9294abeod6e5ece092a487e4@mail.gmail.com>
References: <3a0028490810071321j32b4f450m95123d02b9fe6f49@mail.gmail.com>
	<3a0028490810080734r26912c72n94d6f509dfb55b6e@mail.gmail.com>
	<BLU102-W53021316E8139B5A348338A13B0@phx.gbl>
	<3a0028490810080919v3762f924je688a56210558e95@mail.gmail.com>
	<BLU102-W420C4D08216238B5121B32A13B0@phx.gbl>
	<3a0028490810080934l211d137uc9dde69cad7879d9@mail.gmail.com>
	<48EC9D9F.EE98.0025.0@wicourts.gov>
	<3a0028490810081054o2100b2bci7bde6b7213712c58@mail.gmail.com>
	<48ECB0DD.EE98.0025.0@wicourts.gov>
	<dcc563d10810081116g6aece154rbadf99951ab4caa2@mail.gmail.com>
	<3a0028490810090802t9294abeod6e5ece092a487e4@mail.gmail.com>

On Thu, 2008-10-09 at 13:02 -0200, Rafael Domiciano wrote:
> Hi there.
> 
> 
> 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.
> 
> 
> 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.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.




view thread (16+ messages)

Message-ID: <1223564762.6070.14.camel@bnicholson-desktop>
Permalink:  ../1223564762.6070.14.camel@bnicholson-desktop/
Also on:    postgresql.org/message-id/1223564762.6070.14.camel@bnicholson-desktop

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: bnichols@ca.afilias.info, rafael.domiciano@gmail.com, scott.marlowe@gmail.com, Kevin.Grittner@wicourts.gov, jcleyva@hotmail.com
  Subject: Re: checkpoint_timeout
  In-Reply-To: <1223564762.6070.14.camel@bnicholson-desktop>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox