| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgres memory question |
| Date: | 2009-08-10 17:49:02 |
| Message-ID: | 2968dfd60908101049t6be1091rcb0689501d416c5d@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Aug 10, 2009 at 9:46 AM, Bill Moran<wmoran(at)potentialtech(dot)com> wrote:
> We have servers using about 200 connections on average ... it climbs up
> to 300+ during busy use. I've seen it peak as high as 450, and we've seen
> no performance issues.
>
> This is a quad core with 4G of RAM. Of course the OS isn't windows, it's
> 64 bit FreeBSD.
I too run 64bit FreeBSD 7.2. However in my primary use case, anything
short of 20GB of RAM makes the application very unresponsive when many
customers are online. We usually don't have more than about 45 to 50
connections simultaneously. My general-use Pg server has 4GB and that
is more than adequate for the miscellaneous uses of blogs, ad servers,
and drupal installations.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-08-10 17:59:56 | Re: using COPY and PARTITON |
| Previous Message | Sam Mason | 2009-08-10 17:08:16 | Re: PQstatus does not seem to work |