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

OK, have installed perf and will report back when the problem gets noticeable.

Martin.

On 04/12/2017, 12:40, "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com> wrote:

On Mon, Dec 4, 2017 at 9:03 PM, Martin Moore <martin(dot)moore(at)avbrief(dot)com> 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 removing the subscription sees this value drop to an expect small value.

When debugging such issues, it is critical to know where the resources
are spent, and you are giving no information that can help in
understanding where CPU cycles are spent. You can do such measurements
by using perf for example.
--
Michael