Multiple databases one directory

From: Noah Silverman <noah(at)allresearch(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Multiple databases one directory
Date: 2003-01-24 22:39:42
Message-ID: BAD36AF8-2FEC-11D7-A3A3-000393AA8F3C@allresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi!

Another fun question in our ongoing analysis on whether to switch from
mysql to postgres. (Just as an update, Postgres has performed
flawlessly on all of our stress tests so far.)

We have a situation where we will be creating two fairly large and
complex databases with many tables (thousands) each. From what I
understand, postgres keeps everything in one big data directory.

Would there be an advantage to putting each of the two databases into a
separate directory and starting two instances of postgres? Is it
better to just lump everything together.

In a perfect world, we would buy another database server and raid for
the second database, but being a small company, we just don't have the
budget right now. The raid on our current server is much bigger than we
need.

Thanks,

-N

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Mayer 2003-01-24 23:09:19 Re: Does "correlation" mislead the optimizer on large
Previous Message Noah Silverman 2003-01-24 21:55:45 Re: Does "correlation" mislead the optimizer on large