Re: High CPU on read-only streaming replication server

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Nick <nboutelier(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: High CPU on read-only streaming replication server
Date: 2012-07-21 10:22:30
Message-ID: 500A82E6.8070100@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2012-07-21 11:03:40 Re: Get DB Size by row
Previous Message Herouth Maoz 2012-07-21 08:59:49 Why is an ISO-8859-8 database allowing values not within that set?