Re: BUG #14530: Logical Decoding Slowness

On 2017-02-09 04:52:41 +0000, Huan Ruan wrote:
> Hi Andres
>
> Thanks for your reply.
>
> On Thu, 9 Feb 2017 at 14:29 Andres Freund <andres(at)anarazel(dot)de> wrote:
>
> > Hi,
> >
> > I have a suspicion what's causing this, but would it be possible for you
> > to run a profile (with perf or such) and report the result?
> >
>
> Attached
>
> - perf.data.subtran100k.gz is 'perf record -a -g -s -- ' output for the
> pg_logical_slot_get_changes() query in script 1 for 100,000 subtransactions.
> - perf.data.createtable5k.gz is 'perf record -a -g -s -- ' output for
> the pg_logical_slot_get_changes() query in script 2 for 5,000 create tables
> in one transaction.

Unfortunately perf files can't be interpreted on other systems unless
you added all the referenced object files to it using perf archive.
Could you perhaps just send the first few lines of the report?

Greetings,

Andres Freund