Re: [BUGS] BUG #14530: Logical Decoding Slowness - Mailing list pgsql-bugs

From Andres Freund
Subject Re: [BUGS] BUG #14530: Logical Decoding Slowness
Date
Msg-id 20170210054344.iorgrrtfpf7jshhq@alap3.anarazel.de
Whole thread Raw
In response to Re: [BUGS] BUG #14530: Logical Decoding Slowness  (Huan Ruan <leohuanruan@gmail.com>)
Responses Re: [BUGS] BUG #14530: Logical Decoding Slowness  (Huan Ruan <leohuanruan@gmail.com>)
List 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 by date:

Previous
From: Huan Ruan
Date:
Subject: Re: [BUGS] BUG #14530: Logical Decoding Slowness
Next
From: Huan Ruan
Date:
Subject: Re: [BUGS] BUG #14530: Logical Decoding Slowness