Re: [BUGS] BUG #14530: Logical Decoding Slowness

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [BUGS] BUG #14530: Logical Decoding Slowness
Дата
Msg-id 20170210054344.iorgrrtfpf7jshhq@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14530: Logical Decoding Slowness  (Huan Ruan <leohuanruan@gmail.com>)
Ответы Re: [BUGS] BUG #14530: Logical Decoding Slowness
Список pgsql-bugs
Hi,

On 2017-02-10 05:33:17 +0000, Huan Ruan wrote:
> I might have given you the create table perf data for the subtran case.
> 
> We profiled again with debug info on today, and the results are
> 
> Subtran:
> 
>   Children      Self  Command Shared Object                       Symbol
> +   94.84%     0.00%  postgres postgres                            [.]
> ExecMakeTableFunctionResult
> +   94.84%     0.00%  postgres postgres                            [.]
> pg_logical_slot_get_changes_guts
> +   94.80%     0.00%  postgres postgres                            [.]
> LogicalDecodingProcessRecord
> +   94.45%     0.03%  postgres postgres                            [.]
> ReorderBufferCommit
> +   94.19%     0.01%  postgres postgres                            [.]
> ReorderBufferCleanupTXN
> +   94.11%     0.01%  postgres postgres                            [.]
> ReorderBufferReturnChange
> +   94.08%    93.40%  postgres postgres                            [.]
> AllocSetFree

Could you give a bit more detail abou thtis one - it indeed looks like
different profile, but it's hard to nail down without more lines...

Andres


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Huan Ruan
Дата:
Сообщение: Re: [BUGS] BUG #14530: Logical Decoding Slowness
Следующее
От: Huan Ruan
Дата:
Сообщение: Re: [BUGS] BUG #14530: Logical Decoding Slowness