Skip site navigation (1) Skip section navigation (2)

checkpoint_timeout

From: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: checkpoint_timeout
Date: 2008-10-07 20:21:47
Message-ID: 3a0028490810071321j32b4f450m95123d02b9fe6f49@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: chirag.daveDate: 2008-10-07 21:13:38
Subject: Re: checkpoint_timeout
Previous:From: Shane AmblerDate: 2008-10-07 17:49:02
Subject: Re: Postgres database as a client/server architecture

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group