| 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: | Whole Thread | Raw Message | 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 |