High CPU on read-only streaming replication server
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?
BTW, Its version 9.1.4 on a 2.2Ghz dual processor with 17GB of ram.
On Jul 19, 1:23 pm, Nick <nboutel...@gmail.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%
On 07/20/2012 04:44 AM, Nick wrote:
BTW, Its version 9.1.4 on a 2.2Ghz dual processor with 17GB of ram.
Sample queries?
EXPLAIN (ANALYZE, VERBOSE) ?
How many concurrent queries? What's the connection limit on the pooler?
How big is shared_buffers?
--
Craig Ringer