Re: How can I have 2 completely seperated databases in PostgreSQL?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: hong(dot)ge(at)yale(dot)edu
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How can I have 2 completely seperated databases in PostgreSQL?
Date: 2004-02-12 15:19:16
Message-ID: 20040212151916.GA4001@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Feb 11, 2004 at 17:48:51 -0500,
hong(dot)ge(at)yale(dot)edu wrote:
> Thank you very much for your reply. I'd like to discuss the why.
>
> I don't think letting them share data and logs could gain me something.
> And if I have 2 databases totally not relevant, I think the most natural
> way is to make them totally seperated. Does the sharing buys me
> anything? If not, what's the reason of doing it?

They would both use the same shared memory segment. If you are short on
memory running two clusters may make the problem worse.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-02-12 15:27:31 Re: Circular-freelist bug is still there
Previous Message Tom Lane 2004-02-12 15:18:02 Re: Transaction aborts on syntax error.