On 09/29/12 11:43 AM, Jeff Janes wrote:
>http://serverfault.com/questions/433281/doubled-up-ram-to-32-gb-now-how-to-speed-up-a-lapp-server
If you expand the "COMMAND" field of the "top" display (by hitting "c"
on my linux), you can probably see what the top "postmaster" process
is doing.
Anyway, it looks like your server is mostly bored. If there is a
specific performance problem, it might be in the client side, or
network latency.
assuming the PP stands for PHP + Postgres, another likely candidate for
performance issues is PHP opening (and closing) a new connection for
each page. use pgbouncer as a connection pool and watch things speed
up considerably.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
