John R Pierce <pie...@hogranch.com> writes:
> one of the reasons PostgreSQL is less popular with shared hosting
> services is that there is insufficient isolation between database
> users. For instance, one user leaves a <Idle in TransactioN> pending
> due to sloppy programming, and the entire cluster eventually can't be
> vacuumed. There's numerous other places where the isolation between
> postgres users is insufficient (visibility of information in pg_catalog,
> for instance).
If you want that level of isolation, you have to give each user his own
cluster.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
