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?
Best Regards, Simon Riggs
pgsql-admin by date
|Next:||From: Lathika Wijerathne||Date: 2005-07-27 05:51:28|
|Subject: User Define Functions|
|Previous:||From: Jaime Casanova||Date: 2005-07-26 19:49:15|
|Subject: Re: [pgsql-es-ayuda] bien, esta es mi duda sobre almacenamiento de datos grandes en una columna|