Re: Postgres Replaying WAL slowly

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: Postgres Replaying WAL slowly
Дата
Msg-id 37F64AA0-5040-4158-822B-A0F8F7B763A8@pgexperts.com
обсуждение исходный текст
Ответ на Re: Postgres Replaying WAL slowly  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список 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 по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Postgres Replaying WAL slowly
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Postgres Replaying WAL slowly