Thread: Checkpoint segments

Checkpoint segments

From
Simon Riggs
Date:
If I have a system that writes out one WAL file every 5 minutes, and I
have these settings:

checkpoint_timeout = 3329
checkpoint_segments = 1000
(parameters checked as valid via pg_settings)

How many WAL files would you expect to see in pg_xlog, once the system
has reached steady state?

I would expect checkpoints to occur every 3329 seconds, giving on
average 10-11 WAL files per checkpoint. So, I expect to find up to 23
WAL files in the pg_xlog directory.

I have 308 files in pg_xlog, which remains constant. The oldest file
time is approximately 24 hours ago.

Am I just tired, or is that a little strange?

pg 7.4.6

Best Regards, Simon Riggs


Re: Checkpoint segments

From
Simon Riggs
Date:
On Tue, 2005-07-26 at 23:22 +0100, Simon Riggs wrote:
> If I have a system that writes out one WAL file every 5 minutes, and I
> have these settings:
>
> checkpoint_timeout = 3329
> checkpoint_segments = 1000
> (parameters checked as valid via pg_settings)
>
> How many WAL files would you expect to see in pg_xlog, once the system
> has reached steady state?
>
> I would expect checkpoints to occur every 3329 seconds, giving on
> average 10-11 WAL files per checkpoint. So, I expect to find up to 23
> WAL files in the pg_xlog directory.
>
> I have 308 files in pg_xlog, which remains constant. The oldest file
> time is approximately 24 hours ago.
>
> Am I just tired, or is that a little strange?

Just tired it is, of course.

Checkpoints were occurring every 3329 seconds, but the number of files
was not reducing because it is less than checkpoint_segments.

The setting of 1000 was originally chosen to be large enough so that the
checkpoint would occur only at the timeout. However, that means the only
limit placed on the size of pg_xlog was 2001 files. Since we have 308,
older files were not removed.

Best Regards, Simon Riggs