pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andres Freund <andres@2ndquadrant.com>
To: Jeff Frost <jeff@pgexperts.com>
Cc: Soni M <diptatapa@gmail.com>
Cc: Heikki Linnakangas <hlinnakangas@vmware.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres Replaying WAL slowly
Date: Mon, 30 Jun 2014 20:39:08 +0200
Message-ID: <20140630183908.GT26930@awork2.anarazel.de> (raw)
In-Reply-To: <8DA8C140-818D-4184-AAE6-CA37278B983C@pgexperts.com>
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>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

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



view thread (33+ messages)  latest in thread

Message-ID: <20140630183908.GT26930@awork2.anarazel.de>
Permalink:  ../20140630183908.GT26930@awork2.anarazel.de/
Also on:    postgresql.org/message-id/20140630183908.GT26930@awork2.anarazel.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: andres@2ndquadrant.com, jeff@pgexperts.com, diptatapa@gmail.com, hlinnakangas@vmware.com
  Subject: Re: Postgres Replaying WAL slowly
  In-Reply-To: <20140630183908.GT26930@awork2.anarazel.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox