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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> 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 

-Josh Berkus
 Aglio Database Solutions
 San Francisco

In response to


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-2017 The PostgreSQL Global Development Group