From: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
---|---|
To: | Jov <amutu(at)amutu(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: pg_basebackup - odd performance |
Date: | 2014-10-07 19:55:48 |
Message-ID: | CANPAkgvxjyxsXAmN53D6cn_cWm1L_3Ex-NG4uL20dPp3v62EAQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com
<http://www.rrdonnelley.com/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*
On Mon, Oct 6, 2014 at 9:59 PM, Jov <amutu(at)amutu(dot)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(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 | Marti Raudsepp | 2014-10-07 20:26:38 | Re: query plan question, nested loop vs hash join |
Previous Message | Tom Lane | 2014-10-07 13:56:34 | Re: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660 |