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