Обсуждение: pg_basebackup - odd performance

Поиск
Список
Период
Сортировка

pg_basebackup - odd performance

От
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?

__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com


Re: pg_basebackup - odd performance

От
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" <mike.blackwell@rrd.com>写道：
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?

__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com


Re: pg_basebackup - odd performance

От
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 Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com



On Mon, Oct 6, 2014 at 9:59 PM, Jov <amutu@amutu.com> wrote:

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" <mike.blackwell@rrd.com>写道：

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?

__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com