Re: BUG #9635: Wal sender process is using 100% CPU - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #9635: Wal sender process is using 100% CPU
Date
Msg-id 20140507074050.GC22053@awork2.anarazel.de
Whole thread Raw
In response to BUG #9635: Wal sender process is using 100% CPU  (jkoceniak@mediamath.com)
List pgsql-bugs
Hi,

On 2014-05-07 03:02:22 +0000, Jamie Koceniak wrote:
> The ssl option is on in postgres.conf but we don't have any hostssl lines or cert configured as an authentication
methodin our pg_hba.conf file. 

Add sslmode=disable to the standby's primary_conninfo to be certain. The
profile suggests ssl is active. 'host' allows ssl connections, it just
doesn't force them to be used.

Also, zlib seems to be a contention point. If that profile is from a
standby, could it be that you're concurrently generating base backups?
Or compressing files in a archive_command?

Greetings,

Andres Freund

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

pgsql-bugs by date:

Previous
From: Rainer Tammer
Date:
Subject: Re: Problem with PostgreSQL 9.2.7 and make check on AIX 7.1
Next
From: Cécile Tonglet
Date:
Subject: pg_ctl of postgres 8.4 doesn't behave the same than 9.x when using a custom unix socket path