We recently had a problem with wal archiving badly impacting the
performance of our postgresql master.
And i discovered "cstream", that can limite the bandwidth of pipe stream.
Here is our new archive command, FYI, that limit the IO bandwidth to 500KB/s :
archive_command = '/bin/cat %p | cstream -i "" -o "" -t -500k | nice
gzip -9 -c | /usr/bin/ncftpput etc...'
PS : While writing that mail, i just found that i could replace :
cat %p | cstream -i "" ...
cstream -i %p ...
Sysadmin & DBA @ http://Www.over-blog.com/
pgsql-performance by date
|Next:||From: Kenneth Marshall||Date: 2009-11-10 13:41:24|
|Subject: Re: limiting performance impact of wal archiving.|
|Previous:||From: Greg Smith||Date: 2009-11-09 17:04:21|
|Subject: Re: CREATE TABLE slowing down significantly over time|