From: | Jov <amutu(at)amutu(dot)com> |
---|---|
To: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: pg_basebackup - odd performance |
Date: | 2014-10-07 02:59:30 |
Message-ID: | CADyrUxOuH2cFkgAwAdpyyF8TekMpE_khQ9CWHGizv7r9na6hmQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(dot)blackwell(at)rrd(dot)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(dot)Blackwell(at)rrd(dot)com
> http://www.rrdonnelley.com
>
>
> <http://www.rrdonnelley.com/>
> * <Mike(dot)Blackwell(at)rrd(dot)com>*
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Kamarzin | 2014-10-07 10:13:35 | Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660 |
Previous Message | jaime soler | 2014-10-06 21:10:38 | Re: <idle> issue? |