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
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