Slow system due to ReorderBufferGetTupleBuf?

From: Martin Moore <martin(dot)moore(at)avbrief(dot)com>
To: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Slow system due to ReorderBufferGetTupleBuf?
Date: 2018-01-01 16:56:13
Message-ID: 34E81031-B9DC-4626-97F6-B78AC45959D1@avbrief.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgres v10 on Debian stretch

I’m suffering from an occasionally very slow system. A few weeks ago someone mentioned using perf. I’ve installed this and caught the system during a slow period. It shows the following as the top cpu users:

9.09% postgres [.] ReorderBufferGetTupleBuf
6.14% postgres [.] ReorderBufferReturnChange

When ReorderBufferReturnChange is no longer running:

14.35% postgres [.] ReorderBufferGetTupleBuf

Can someone shed some light on this and advise how to prevent it reoccurring?

Cheers,

Martin.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Graeme 2018-01-01 17:42:28 Use of Port 5433 with Postgresql 9.6
Previous Message Alexander Farber 2018-01-01 16:15:54 Re: Selecting a JSON object of arrays from a PostgreSQL table