2010/11/1 hubert depesz lubaczewski <[email protected]>: > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 * > checkpoint_segments ).
why? for a server overloaded with R/W transactions, it's possible to go beyond this. checkpoints just do not keep up. right now I have an 8.3 with checkpoint_segments=3, constantly running pgbench and I see 8 WAL segments. cheers Filip -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
