Re: High CPU on read-only streaming replication server

From: Nick <nboutelier(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: High CPU on read-only streaming replication server
Date: 2012-07-19 21:11:07
Message-ID: 1ef6181b-0498-41c2-a98f-b1e8c0052d0c@re8g2000pbc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jul 19, 1:23 pm, Nick <nboutel(dot)(dot)(dot)(at)gmail(dot)com> wrote:
> My read-only streaming replication servers are showing a much higher
> CPU load than I would expect.
>
> None of my queries are longer than 10ms.
>
> My application server is connecting to this server via pgbouncer.
>
> Other than that, its a pretty standard setup. I haven't toyed with too
> many settings besides the standard optimization settings.
>
> Any ideas what could be going on?

One more thing to point out, the top process that shows high CPU is...
COMMAND: postgres: dbuser mydatabase X.XX.XXX.XXX(XXXX) idle
CPU%: 68%

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark Wynter 2012-07-20 00:57:26 Problem setting environmental variables for postgresql or plpythonu
Previous Message Adam Crews 2012-07-19 20:56:48 postgres 9 bind address for replication