Re: BUG #9635: Wal sender process is using 100% CPU

Hi Andres,

The ssl option is on in postgres.conf but we don't have any hostssl lines o=
r cert configured as an authentication method in our pg_hba.conf file.

In our pg_hba.conf we have configured each replication host as trust:
host    replication     all             xx.xxx.xxx.xx/32        trust

I replied in a previous email that we have a job that inserts 30+ million r=
ecords into a table.
During the loading of this table, the wal_sender cpu spikes to 100% and app=
ears to stay at 100% until the replication is completed on the slave.
I have been able to reproduce this.  Other than offloading this job, is the=
re anything we can do to improve the replication lag?

Thanks!

-----Original Message-----
From: Andres Freund [mailto:andres@2ndquadrant.com]=20
Sent: Tuesday, May 06, 2014 3:42 PM
To: Jamie Koceniak
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #9635: Wal sender process is using 100% CPU

Hi,

On 2014-03-19 17:13:56 +0000, jkoceniak@mediamath.com wrote:
> Periodically throughout the day, we keep seeing the wal sender process=20
> utilize 100% of the CPU. We began noticing this after we added 2 new=20
> slave servers, going from 2 to 4 slaves. See top results and I also=20
> included our wal settings. Thanks!

A typical reason for this is that the standbys are connecting over ssl. Is =
that the case? If so, intentionally?

Greetings,

Andres Freund

--=20
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services