. and make sure permissions are such, that I can hop = databases with just one connection I get from the pool.=20 I can't find a similiar technique in postgres. Am I missing a way to hop = databases w/o having to create a new connection ?? It is adding 5x the = performance hit if I have to get a NEW connection everytime I need to = hop. I hate to have to create a connection pool for every database we = have on our box. (worried about memory consumption) Thanks .... ------=_NextPart_000_0085_01BE6963.4F1A3930 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

We are trying to port our pure java e-commerce = software to=20 postgres. I am using database pooling with jdbc during an init stage of = the main=20 servlet that dishes out the html content to the users. (we must use = pooling,=20 because it takes too darn long to get a connection, and we need our web = pages to=20 respond quickly)

My problem is that we use multiple databases per web = request.=20 With other db's, I can make a connection to a central db, and then = select ..=20 from <database>.<table> and make sure permissions are such, = that I=20 can hop databases with just one connection I get from the pool. =

I can't find a similiar technique in postgres. Am I = missing a=20 way to hop databases w/o having to create a new connection ?? It is = adding 5x=20 the performance hit if I have to get a NEW connection everytime I need = to hop. I=20 hate to have to create a connection pool for every database we have on = our box.=20 (worried about memory consumption)

Thanks ....

------=_NextPart_000_0085_01BE6963.4F1A3930--