Re: PG vs MySQL - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: PG vs MySQL
Date
Msg-id 5.2.1.1.1.20040330212112.0339c7c0@mbox.jaring.my
Whole thread Raw
In response to Re: PG vs MySQL  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
At 06:16 PM 3/29/2004 -0600, Mike Nolan wrote:

> > Now, that doesn't preclude clients from seeing the names of another
> > clients database using \l, but unless there is gross mis-management of the
> > pg_hba.conf, seeing the names of other databases doesn't give other
> > clients any benefits ...
>
>That rather depends upon what those clients are doing, doesn't it?
>
>I can see benefits from being able to completely isolate one client/database
>from another,  even to the point of not giving them any hints that they're
>sharing the same database server.  (Depending on how fanatical I am about
>it, there are other solutions, such as separate instances or completely
>separate physical systems, but those present a different set of
>administrative issues.)

It would just be better to run separate postgres instances.

The resources used may be higher, but the isolation is better.

If RAM was cheaper I'd give each customer their own virtual machine.

Regards,
Link.



pgsql-general by date:

Previous
From: Gregory Wood
Date:
Subject: Re: PG vs MySQL
Next
From: "Chris Boget"
Date:
Subject: Re: Can we have time based triggers in Postgresql??