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
--
Sent via pgsql-general
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 besid
BTW, Its version 9.1.4 on a 2.2Ghz dual processor with 17GB of ram.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jul 19, 1:23 pm, Nick 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
