2010/11/1 hubert depesz lubaczewski <depesz(at)depesz(dot)com>:
> 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