On 8 Prosinec 2011, 18:00, Marc Cousin wrote: > 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 :) Because Oracle uses schemas instead of databases. One schema = one user = one database. Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
