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
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
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
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