Re: BUG #14530: Logical Decoding Slowness

From: Andres Freund <andres(at)anarazel(dot)de>
To: Huan Ruan <leohuanruan(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14530: Logical Decoding Slowness
Date: 2017-02-10 05:43:44
Message-ID: 20170210054344.iorgrrtfpf7jshhq@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Huan Ruan 2017-02-10 06:33:30 Re: BUG #14530: Logical Decoding Slowness
Previous Message Huan Ruan 2017-02-10 05:33:17 Re: BUG #14530: Logical Decoding Slowness