Postgres Pro
Downloads
Home   >   mailing lists

Slow system due to ReorderBufferGetTupleBuf? - Mailing list pgsql-general

From Martin Moore
Subject Slow system due to ReorderBufferGetTupleBuf?
Date
Msg-id 34E81031-B9DC-4626-97F6-B78AC45959D1@avbrief.com
Whole thread Raw
Responses Re: Slow system due to ReorderBufferGetTupleBuf?  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-general
Tree view 
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
andcaught 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.

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Selecting a JSON object of arrays from a PostgreSQL table
Next
From: Graeme
Date:
Subject: Use of Port 5433 with Postgresql 9.6