Re: [GENERAL] Number of WAL segment

Thanks, I am confused now.When checkpoint_segment is set to 3 there are 7 WAL segments in pg_xlog.When I set checkpoint_segments to 10 there are 11 WAL segments. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Number-of-WAL-segment-tp5771221p5771321.html Sent from the

[GENERAL] Number of WAL segment

Hi, I am using PostgreSQL 8.3.8!!! How can I increase number of WAL segments in pg_xlog??? Current settings are: checkpoint_segments=10 checkpoint_completion_target=0.5 WAL segments are generated every 10 min and I want to keep WAL segments in pg_xlog for at least 3h. Thanks... -- View this m