Re: Maximum number of concurrent users

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Kesavan" <kesavan(at)emmeskay(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Cc: "Premshaw" <premshaw(at)emmeskay(dot)com>
Subject: Re: Maximum number of concurrent users
Date: 2008-08-04 17:03:07
Message-ID: 4896EFFB.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>> Kesavan <kesavan(at)emmeskay(dot)com> wrote:

> In specific, can Postgres handle 1000 concurrent queries?

It can.

> We are using normal Pentium Quad core processor, 3GHZ system with 2GB

> RAM as Database Server.

With four processors, depending on your drive array configuration, you
are likely to get better performance funneling the requests through a
connection pool of about 8 to 16 connections. (With a lot of
spindles, maybe more.)

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2008-08-04 17:46:07 Re: Maximum number of concurrent users
Previous Message Kesavan 2008-08-04 15:49:11 Maximum number of concurrent users