OK, have installed perf and will report back when the problem gets noticeable.
Martin.
On 04/12/2017, 12:40, "Michael Paquier" wrote:
On Mon, Dec 4, 2017 at 9:03 PM, Martin Moore
wrote:
> After a few days, it’s noticeable that the Postgres on the publisher node
is constantly using a
On Mon, Dec 4, 2017 at 9:03 PM, Martin Moore wrote:
> After a few days, it’s noticeable that the Postgres on the publisher node is
> constantly using a lot of cpu (26% today) and having a big impact on the
> system performance even when doing very little. Logging on to the subscriber
> and remo
I’ve got two Postgres 10/Debian stretch systems and have added a
publish/subscribe on a single table that isn’t updated very often. The
subscriber node is doing very little else.
After a few days, it’s noticeable that the Postgres on the publisher node is
constantly using a lot of cpu (26% toda
