Simmultanous Connections

From: Jude Weaver <exec(at)shreve(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Simmultanous Connections
Date: 2000-01-10 09:21:13
Message-ID: 3879A489.29C77DB8@shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Our company is converting to either PostgreSQL or MySQL. We are leaning
toward postgresql, but,
we still have a few question about PostgreSQL's ability to handle the
traffic at our shop. I would
appreciate any help you can give me.

1. If a user runs a JAVA program that opens 3 postgresql databases, is
that 1 connection or 3 connections? Is there a connection when the
database is opened, or only when the frontend passes
the job to the backend?

2. I read the Q&A on PostgreSQL and I said that more than 32
simmultanous connections could
drain my resources. Can someone tell me how much resources are used per
connection?

3. If I have 90 teachers posting grades at the same time (grade posting
has 5 databases open at
once) and 25 administrators poking around in assorted databases
looking at this and that bit of
info. Will PostgreSQL handle this much activity? This is a
resource list : Our Linux boxes are
from 166 to 450 Mz, 128 MG of RAM and 6.2 to 13 GIG of Diskspace.
The databases will reside
on the Linux boxes and the users access them over Windows work
stations. The applications are
in JAVA.

Thanks in advance for any help you can give me.
Jude Weaver.

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-01-10 15:17:49 Re: [SQL] query to do a backward 'skip', possible with (index) optimization ?
Previous Message Richard Walker 2000-01-09 23:02:20 Re: [SQL] Serial field starting at 100 ?