<br /><p><font face="Courier New" size="2">With the parameter checkpoint_segment and wal_keep_segments the max. number
ofwal segments are set. If now the max number is reached, </font><p><font face="Courier New" size="2">(1) the segments
aredeleted/recycled </font><br /><font face="Courier New" size="2">or (2) if the time set by the checkpoint_timeout is
over,a checkpoint is set and if possible a deletion/recycling is done. </font><p><font face="Courier New" size="2">This
isthe mechanism on the active side of a db server. On the standby side however only unused tranferred segments will be
deletedif the checkpoint_timeout mechanism (2) is executed.</font><p><b><font face="Courier New" size="2">Is this a
correctbehaviour or it is an error?</font></b><br /><font face="Courier New" size="2"> </font><br /><font face="Courier
New"size="2">I have observed (checkpoint_segment set to 3; wal_keep_segments set to 10 and checkpoint_timeout set to
30min)that in my stress test the disk usage on standby side is increased up to 2GB with xlog segments whereby on the
activeside only ~60MB xlog files are available (we have patched the xlog file size to 4MB). To prevent this one
possibilityis to decreace the checkpoint_timeout to a low value (30sec), however this had the disadvantage that a
checkpointis often executed on active side which can influence the performance. Another possibility is to have
differentpostgresql.conf on active and on standby side, but this is not our preferred solution. </font><br /><br
/><p><i><fontcolor="#000000" face="Brush Script MT" size="4">Best Regards/mfG</font></i><br /><i><b><font
color="#FF0000"face="Brush Script MT" size="6">Ingo Sander</font></b></i><br /><font face="Times New Roman"
size="2">=========================================================</font><br/><font face="Arial Black" size="2">Nokia
SiemensNetworks GmbH &Co. KG</font><br /><span lang="en-us"><font face="Courier New" size="2">NWS EP CP SVSS
PlatformTech Support DE</font></span><br /><span lang="en-us"><font face="Courier New" size="2">St.-Martin-Str.
76</font></span><br/><span lang="en-us"><font face="Courier New" size="2">D-81541 München</font></span><br /><span
lang="de"><fontcolor="#008080" face="Wingdings" size="5">(</font><font face="Tahoma" size="2">Tel.:
+49-89-515938390</font></span><br/><span lang="de"><font color="#008080" face="Wingdings"
size="5">+</font><u></u><u></u><u><fontcolor="#0000FF" face="Tahoma" size="2">ingo.sander@nsn.com</font></u></span><br
/>