[HACKERS] Streaming Replication: Checkpoint_segment and wal_keep_segments on standby
in [PgSql]
|
Prev: [HACKERS] Straightforward Synchronous Replication
Next: Streaming Replication: Checkpoint_segment and wal_keep_segments on standby
From: ingo.sander on 27 May 2010 09:13 With the parameter checkpoint_segment and wal_keep_segments the max. number of wal segments are set. If now the max number is reached, (1) the segments are deleted/recycled or (2) if the time set by the checkpoint_timeout is over, a checkpoint is set and if possible a deletion/recycling is done. This is the mechanism on the active side of a db server. On the standby side however only unused tranferred segments will be deleted if the checkpoint_timeout mechanism (2) is executed. Is this a correct behaviour or it is an error? 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 active side only ~60MB xlog files are available (we have patched the xlog file size to 4MB). To prevent this one possibility is to decreace the checkpoint_timeout to a low value (30sec), however this had the disadvantage that a checkpoint is often executed on active side which can influence the performance. Another possibility is to have different postgresql.conf on active and on standby side, but this is not our preferred solution. Best Regards/mfG Ingo Sander ========================================================= Nokia Siemens Networks GmbH &Co. KG NWS EP CP SVSS Platform Tech Support DE St.-Martin-Str. 76 D-81541 München *Tel.: +49-89-515938390 *ingo.sander(a)nsn.com |