Re: an enhancement idea

John R Pierce <pierce@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