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

Checkpoint segments

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Checkpoint segments
Date: 2005-07-26 22:22:34
Message-ID: 1122416554.3670.109.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-admin
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


Responses

pgsql-admin by date

Next:From: Lathika WijerathneDate: 2005-07-27 05:51:28
Subject: User Define Functions
Previous:From: Jaime CasanovaDate: 2005-07-26 19:49:15
Subject: Re: [pgsql-es-ayuda] bien, esta es mi duda sobre almacenamiento de datos grandes en una columna

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