Re: Would my postgresql 8.4.12 profit from doubling RAM? - Mailing list pgsql-general

From Alexander Farber
Subject Re: Would my postgresql 8.4.12 profit from doubling RAM?
Date
Msg-id CAADeyWhCFyG0qH+u2N3RwARYjP+P_-W_NRiD00X+yD4Mx0Xy-w@mail.gmail.com
Whole thread Raw
In response to Re: Would my postgresql 8.4.12 profit from doubling RAM?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
On Sun, Sep 30, 2012 at 2:36 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>> Whoa aren't you running pg bouncer?  If so then leave pg alone, adjust
>> pg bouncer.  Revert that db side change, examine pgbouncer config etc.
>
>
> apache/php -> (500 persistent conns, cheap) -> pgbouncer -> (20
> persistent pgsql conns, expensive) -> pgsql.
>

I will try that, thanks


pgsql-general by date:

Previous
From: "Waldo, Ethan"
Date:
Subject: transitive pruning optimization on the right side of a join for partition tables
Next
From: Alban Hertroys
Date:
Subject: Re: Installing uuid-ossp on 9.2