[GENERAL] Number of WAL segment

2013-09-17 Thread tdev457
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

Re: [GENERAL] Number of WAL segment

2013-09-17 Thread Suzuki Hironobu
Hi, (13/09/17 21:46), tdev457 wrote: 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

Re: [GENERAL] Number of WAL segment

2013-09-18 Thread tdev457
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

Re: [GENERAL] Number of WAL segment

2013-09-21 Thread Michael Paquier
On Tue, Sep 17, 2013 at 2:35 PM, tdev457 wrote: > 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. The maximum number of WAL files is defined by this formula: (2 + checkpoint_comp

Re: [GENERAL] Number of WAL segment

2013-09-21 Thread Michael Paquier
On Tue, Sep 17, 2013 at 9:46 PM, tdev457 wrote: > 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 se