Re: [PERFORM] pg_basebackup - odd performance

2014-10-07 Thread Mike Blackwell
Thanks for your reply. Adding '-c fast' does seem to improve the initial delay. I'm still seeing delays of several minutes between write bursts. The server has light OLTP loading. __ *Mike Blackwell | Technical Analy

Re: [PERFORM] pg_basebackup - odd performance

2014-10-06 Thread Jov
what is the cmd?the default checkpoint method is spread,so pg_basebackup will wait the checkpoint complete on the master.you can set the checkpoint method to fast to avoid the waiting. 2014年10月7日 2:54 AM于 "Mike Blackwell" 写道: > I'm seeing some strange behavior running pg_basebackup on 9.3.5. It >

[PERFORM] pg_basebackup - odd performance

2014-10-06 Thread Mike Blackwell
I'm seeing some strange behavior running pg_basebackup on 9.3.5. It appears that there are long pauses - up to a couple of minutes - between relatively short bursts of disk activity. I'm not noticing any lock requests outstanding. What might I be missing? ___