Received: from mercury.shreve.net (IDENT:root@mercury.shreve.net [208.206.76.23]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA49233 for ; Mon, 10 Jan 2000 10:22:26 -0500 (EST) (envelope-from exec@shreve.net) Received: from shreve.net (exec.shreve.net [208.214.45.25]) by mercury.shreve.net (8.9.3/8.9.3) with ESMTP id JAA15897 for ; Mon, 10 Jan 2000 09:21:00 -0600 Sender: root@mercury.shreve.net Message-ID: <3879A489.29C77DB8@shreve.net> Date: Mon, 10 Jan 2000 09:21:13 +0000 From: Jude Weaver X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i686) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Simmultanous Connections Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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.