Re: Postgres Replaying WAL slowly

From: Jeff Frost <jeff(at)pgexperts(dot)com>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc: Soni M <diptatapa(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres Replaying WAL slowly
Date: 2014-06-30 17:04:44
Message-ID: 37F64AA0-5040-4158-822B-A0F8F7B763A8@pgexperts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Jun 30, 2014, at 9:14 AM, Heikki Linnakangas <hlinnakangas(at)vmware(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2014-06-30 17:14:16 Re: Postgres Replaying WAL slowly
Previous Message Heikki Linnakangas 2014-06-30 16:14:24 Re: Postgres Replaying WAL slowly