Re: an enhancement idea - Mailing list pgsql-general

From Tom Lane
Subject Re: an enhancement idea
Date
Msg-id 29865.1291580843@sss.pgh.pa.us
Whole thread Raw
In response to an enhancement idea  (John R Pierce <pierce@hogranch.com>)
Responses Re: an enhancement idea  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: pgadmin3 and pgdesigner source
Next
From: John R Pierce
Date:
Subject: Re: an enhancement idea