Re: PATCH: regular logging of checkpoint progress - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: PATCH: regular logging of checkpoint progress
Date
Msg-id 4E56CA27.1050202@agliodbs.com
Whole thread Raw
In response to PATCH: regular logging of checkpoint progress  ("Tomas Vondra" <tv@fuzzy.cz>)
Responses Re: PATCH: regular logging of checkpoint progress
List 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


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pg_restore --no-post-data and --post-data-only
Next
From: Josh Berkus
Date:
Subject: Re: Inputting relative datetimes