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

Re: PATCH: regular logging of checkpoint progress

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PATCH: regular logging of checkpoint progress
Date: 2011-08-25 22:18:15
Message-ID: 4E56CA27.1050202@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tomas,

> I'd like to propose a small patch that allows better checkpoint progress
> monitoring. The patch is quite simple - it adds a new integer GUC
> "checkpoint_update_limit" and every time checkpoint writes this number of
> buffers, it does two things:

I'd rather not have a new GUC if we can avoid it.  What about just
making this some reasonable value (like 1000 buffers) if log_checkpoints
= on?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2011-08-25 22:20:56
Subject: Re: Inputting relative datetimes
Previous:From: Andrew DunstanDate: 2011-08-25 22:15:41
Subject: Re: pg_restore --no-post-data and --post-data-only

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