Re: Maximum number of concurrent users - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Maximum number of concurrent users
Date
Msg-id 4896EFFB.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Maximum number of concurrent users  (Kesavan <kesavan@emmeskay.com>)
List pgsql-admin
>>> Kesavan <kesavan@emmeskay.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

pgsql-admin by date:

Previous
From: Kesavan
Date:
Subject: Maximum number of concurrent users
Next
From: "Scott Marlowe"
Date:
Subject: Re: Maximum number of concurrent users