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


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: (view raw, whole thread or download thread mbox)
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
#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


Rafael Domiciano


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-2017 The PostgreSQL Global Development Group