Re: pg_basebackup - odd performance

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

In response to

Responses

Browse pgsql-performance by date

  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?