Re: Postgres Replaying WAL slowly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Jun 30, 2014, at 9:14 AM, Heikki Linnakangas <hlinnakangas@xxxxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux