Simmultanous Connections
От | Jude Weaver |
---|---|
Тема | Simmultanous Connections |
Дата | |
Msg-id | 3879A489.29C77DB8@shreve.net обсуждение исходный текст |
Список | 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 passesthe 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.
В списке pgsql-sql по дате отправления: