Skip site navigation (1) Skip section navigation (2)

Re: Multiple databases one directory

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Noah Silverman <noah(at)allresearch(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Multiple databases one directory
Date: 2003-01-24 23:22:28
Message-ID: 200301241522.28521.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Noah,

> 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 
postgres.

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 
bother.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Noah SilvermanDate: 2003-01-24 23:59:58
Subject: WEIRD CRASH?!?!
Previous:From: Ron MayerDate: 2003-01-24 23:09:19
Subject: Re: Does "correlation" mislead the optimizer on large

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group