Re: Replication causing publisher node to use excessive cpu over time

2017-12-04 Thread Martin Moore
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

Re: Replication causing publisher node to use excessive cpu over time

2017-12-04 Thread Michael Paquier
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