Postgres Pro
Downloads
Home   >   mailing lists

Re: High CPU on read-only streaming replication server - Mailing list pgsql-general

From Craig Ringer
Subject Re: High CPU on read-only streaming replication server
Date
Msg-id 500A82E6.8070100@ringerc.id.au
Whole thread Raw
In response to Re: High CPU on read-only streaming replication server  (Nick <nboutelier@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Herouth Maoz"
Date:
Subject: Why is an ISO-8859-8 database allowing values not within that set?
Next
From: Bill Moran
Date:
Subject: Re: Get DB Size by row