We have a database of around 700Gb ... its fairly busy with a lot of small transactions.
We generate some times near 100Gb of WAL files per day, this seems like a lot !! We are looking at a secondary data center for DR so the connection would need a large amount of bandwidth based on this volume. Is what we are seeing normal ? Are there any tunable parameters which will reduce the WAL volume ? At present we get several WAL's spat out every minutes ... sometimes loads more when automatic maintenance takes place etc. Dave
