Date: Mon, 30 Jun 2014 20:39:08 +0200
From: Andres Freund <andres@2ndquadrant.com>
To: Jeff Frost <jeff@pgexperts.com>
Cc: Soni M <diptatapa@gmail.com>,
 Heikki Linnakangas <hlinnakangas@vmware.com>,
 pgsql-performance@postgresql.org
Subject: Re: Postgres Replaying WAL slowly
Message-ID: <20140630183908.GT26930@awork2.anarazel.de>
References: 
 <CAAMgDXm5Y9QPELKvCGBrFvPcuR0ENVA1tEYRcazhDSxs6xnX5w@mail.gmail.com>
 <53AFCEE3.4080009@vmware.com>
 <CAAMgDXnKknBDk+Zb3BXau1cKV7y1A0vd9CJpX=vkSTXVGBrZwA@mail.gmail.com>
 <53B10C4C.8090701@vmware.com>
 <CAAMgDX=c8_6tutCDNiu38Z4wguKMGbhqznVNyMiOC5PZBpn1Fw@mail.gmail.com>
 <53B18CE0.4060501@vmware.com>
 <20140630171416.GK21422@awork2.anarazel.de>
 <CAAMgDXnT8cQbwxcNXfFKONrRVAKoGhR-3FWYSX_5gJcFrEMPMQ@mail.gmail.com>
 <8DA8C140-818D-4184-AAE6-CA37278B983C@pgexperts.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <8DA8C140-818D-4184-AAE6-CA37278B983C@pgexperts.com>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On 2014-06-30 11:34:52 -0700, Jeff Frost wrote:
> On Jun 30, 2014, at 10:29 AM, Soni M <diptatapa@gmail.com> wrote:

> > It is 
> >  96.62%  postgres             [.] StandbyReleaseLocks
> >  as Jeff said. It runs quite long time, more than 5 minutes i think
> > 
> > i also use hot standby. we have 4 streaming replica, some of them has active connection some has not. this issue has last more than 4 days. On one of the standby, above postgres process is the only process that consume high cpu load.
> 
> compiled with -fno-omit-frame-pointer doesn't yield much more info:

You'd need to do perf record -ga instead of perf record -a to see
additional information.

But:

>  76.24%  postgres                               [.] StandbyReleaseLocks

already is quite helpful.

What are you doing on that system? Is there anything requiring large
amounts of access exclusive locks on the primary? Possibly large amounts
of temporary relations?

Greetings,

Andres Freund

-- 
 Andres Freund	                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance