From: Michael Loftis <mloftis@xxxxxxxxx>
>>From: Kevn Brannen >>I have an unusual need: I need Pg to slow down. I know, we all want our DB to go faster, but in this case it's speed is working against me in 1 area. >> >>We have systems that are geo-redundant for HA, with the redundancy being handled by DRBD to keep the disks in sync... > drbdsetup allows you to control the sync rates. I was hoping not to have to do that, but the more I think about this I'm realizing that it won't hurt because the network cap is effectively limiting me anyway. :) I can & will do this, maybe at 90% of our bandwidth, so thanks for the suggestion. Still, this is sort of a last resort thing as I believe controlling the DB to be the ultimate need. Thanks! Kevin . |