| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Would my postgresql 8.4.12 profit from doubling RAM? |
| Date: | 2012-09-29 19:21:59 |
| Message-ID: | 50674A57.8000305@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2012-09-29 19:38:55 | Re: Would my postgresql 8.4.12 profit from doubling RAM? |
| Previous Message | Jeff Janes | 2012-09-29 18:43:52 | Re: Would my postgresql 8.4.12 profit from doubling RAM? |