> 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.
You can use the WITH LOCATION option in CREATE DATABASE to put the two
databases into seperate directories *without* running two instances of
For that matter, the databases each have their own directories, by OID number.
Of course, this only helps you if the seperate directories are on seperate
disks/arrays/channels. If everying is on the same disk or array, don't
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Noah Silverman||Date: 2003-01-24 23:59:58|
|Subject: WEIRD CRASH?!?!|
|Previous:||From: Ron Mayer||Date: 2003-01-24 23:09:19|
|Subject: Re: Does "correlation" mislead the optimizer on large |