Re: pg_basebackup - odd performance - Mailing list pgsql-performance

From Jov
Subject Re: pg_basebackup - odd performance
Date
Msg-id CADyrUxOuH2cFkgAwAdpyyF8TekMpE_khQ9CWHGizv7r9na6hmQ@mail.gmail.com
Whole thread Raw
In response to pg_basebackup - odd performance  (Mike Blackwell <mike.blackwell@rrd.com>)
Responses Re: pg_basebackup - odd performance  (Mike Blackwell <mike.blackwell@rrd.com>)
List 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.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


pgsql-performance by date:

Previous
From: jaime soler
Date:
Subject: Re: issue?
Next
From: Vladimir Kamarzin
Date:
Subject: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660