| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lathika Wijerathne | 2005-07-27 05:51:28 | User Define Functions |
| Previous Message | Jaime Casanova | 2005-07-26 19:49:15 | Re: [pgsql-es-ayuda] bien, esta es mi duda sobre almacenamiento de datos grandes en una columna |