Should be no problem, a lot of systems work like this. Also see
pgpool which can be used to minimize the overhead of opening and
closing connections.
http://pgpool.projects.postgresql.org/
On May 31, 2006, at 11:36 AM, Bali László wrote:
I wanna make a web-based program.
The program stores the datas in a PG database. A lot of user can
be, and
the filling of data web forms could take 30 sec -1 min.
My idea is to handle the connection between the C program and the
database: using only ONE PGuser, and at the beginig of data inserting
process I make the connection and at the end of insertion I close the
connection, always.
What do you think? It is working? Can the PG handle the always
opening-closing situation, and a lot of transactions in one period
under
the name of one user ?
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
