Le Thu, 8 Dec 2011 16:27:56 +0000, "Nicholson, Brad (Toronto, ON, CA)" <bnicholson@xxxxxx> a écrit : > On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin <cousinmarc@xxxxxxxxx> > > > wrote: > > > > I wish it was the same (I use and like both pgbouncer and pgpool > > too, and they do a good job, I'm not arguing on that). But > > unfortunately it isn't: you still have the notion of session for > > each connected client in Oracle when using the shared servers model. > > > > It means you keep your session variables, your prepared statements, > > your running transaction, etc… in each individual session while > > having the multiplexing equivalent of a 'statement level' from > > pgbouncer. > > In Oracle - can the pool share connections between DB users and/or > databases on the instance? If the answer is yes to either, that is a > fair bit better than what we can achieve today. Between users yes. But there is only one DB per instance in Oracle :) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
