From: | Huan Ruan <leohuanruan(at)gmail(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #14530: Logical Decoding Slowness |
Date: | 2017-02-09 04:52:41 |
Message-ID: | CAGgcTZsR_+LqZDJ+6q5hBhSmJAY5yOmGj_6DK9x4MAYgee0UjA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
Regards
Huan
Attachment | Content-Type | Size |
---|---|---|
perf.data.subtran100k.gz | application/x-gzip | 4.3 MB |
perf.data.createtable5k.gz | application/x-gzip | 3.4 MB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2017-02-09 06:34:41 | Re: BUG #14530: Logical Decoding Slowness |
Previous Message | Andres Freund | 2017-02-09 03:29:08 | Re: BUG #14530: Logical Decoding Slowness |