Slow system due to ReorderBufferGetTupleBuf?

Поиск
Список
Период
Сортировка
От Martin Moore
Тема Slow system due to ReorderBufferGetTupleBuf?
Дата
Msg-id 34E81031-B9DC-4626-97F6-B78AC45959D1@avbrief.com
обсуждение исходный текст
Ответы Re: Slow system due to ReorderBufferGetTupleBuf?  (Peter Geoghegan <pg@bowt.ie>)
Список 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
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 по дате отправления:

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Re: Selecting a JSON object of arrays from a PostgreSQL table
Следующее
От: Graeme
Дата:
Сообщение: Use of Port 5433 with Postgresql 9.6