Skip site navigation (1) Skip section navigation (2)

Reality check

From: John Gage <jsmgage(at)numericable(dot)fr>
To: NOVICE Postgres elist <pgsql-novice(at)postgresql(dot)org>
Subject: Reality check
Date: 2010-05-28 07:23:44
Message-ID: EB2B8E8D-8290-4270-AB00-6CB20CE545E4@numericable.fr (view raw or flat)
Thread:
Lists: pgsql-novice
Configuration:

one database

three tables, none more than a few thousand rows with only a few  
fields per row

one, repeat one, perl cgi script on the server

4,500 users simultaneously invoking the cgi script via http requests  
from remote browsers (simultaneously meaning within perhaps seconds of  
each other)

Each invocation of the script opens and closes a connection to the  
database, implying perhaps 4,500 ~simultaneous~ connections to the  
database

The script uses a single, repeat single/unique, *postgres* user to  
access the database, a user who has read and write privileges on the  
tables but that's it (no table creation, etc)

In other words, there are 4,500 unique users accessing the website,  
each uniquely identified via http authentication, but only ONE  
postgres user who they all share to access the database, which implies  
that a single, unique postgres user will be opening and closing  
connections to the database perhaps a thousand times a minute.

Does this work?

If it doesn't, are there any suggestions?

Thanking you very much for time and thoughts,

John Gage

P.S. Internet users are identified within the tables in a field  
containing their Apache environmental variable user name.  They cannot  
collide with each other in the tables.





Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2010-05-28 07:56:47
Subject: Re: Reality check
Previous:From: Dave StrenskiDate: 2010-05-28 02:49:31
Subject: Re: Does PstgreSQL run on the Cray XMT?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group