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 20170209063441.7esfyhtqkwwl6y7f@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
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@anarazel.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


-- 
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