John R Pierce <pierce(at)hogranch(dot)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