Re: Postgres Replaying WAL slowly - Mailing list pgsql-performance

From Jeff Frost
Subject Re: Postgres Replaying WAL slowly
Date
Msg-id 37F64AA0-5040-4158-822B-A0F8F7B763A8@pgexperts.com
Whole thread Raw
In response to Re: Postgres Replaying WAL slowly  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-performance
On Jun 30, 2014, at 9:14 AM, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:

> On 06/30/2014 05:46 PM, Soni M wrote:
>> Here's what 'perf top' said on streaming replica :
>>
>> Samples: 26K of event 'cpu-clock', Event count (approx.): 19781
>>  95.97%  postgres                             [.] 0x00000000002210f3
>
> Ok, so it's stuck doing something.. Can you get build with debug symbols installed, so that we could see the function
name?
> - Heikki
>

Looks like StandbyReleaseLocks:

Samples: 10K of event 'cpu-clock', Event count (approx.): 8507
 89.21%  postgres                  [.] StandbyReleaseLocks
  0.89%  libc-2.12.so              [.] __strstr_sse2
  0.83%  perf                      [.] 0x000000000005f1e5
  0.74%  [kernel]                  [k] kallsyms_expand_symbol
  0.52%  libc-2.12.so              [.] memchr
  0.47%  perf                      [.] symbols__insert
  0.47%  [kernel]                  [k] format_decode

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Postgres Replaying WAL slowly
Next
From: Andres Freund
Date:
Subject: Re: Postgres Replaying WAL slowly