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