Re: pg_basebackup - odd performance

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>*
>>
>

In response to

Browse pgsql-performance by date

  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