From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | lockhart(at)alumni(dot)caltech(dot)edu (Thomas G(dot) Lockhart) |
Cc: | hackers(at)postgresql(dot)org (PostgreSQL-development) |
Subject: | Re: [HACKERS] Alternate locations for databases |
Date: | 1998-01-11 20:48:39 |
Message-ID: | 199801112048.PAA08801@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Just checking to make sure this properly documented for 6.3 beta. Is
it?
>
> > > CREATE DATABASE dbname WITH LOCATION = 'dbpath';
> > How much work would it be to also be able to specify an alternate
> > path for a table within a database? I have some multi-Gb tables
> > and am scrambling for room. If I could have the tables on separate
> > disks, that'd be wonderful.
>
> Well, it is (almost) trivial to get the full database in a different location;
> in fact I put into service an unused column in pg_database which had clearly
> been defined for this purpose. Probably not so trivial for individual tables,
> indices, etc. If it is not on the ToDo list, perhaps Bruce could add it? I'm
> probably not going to pursue it at the moment, myself, but would be happy to
> work with someone if they want to do it :) As an aside, there is _no_
> performance penalty for alternate database locations, but there might be for
> distributed tables/indices since the location would need to be looked up at
> least occasionally.
>
>
--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-01-11 20:49:57 | Re: [HACKERS] TODO addition |
Previous Message | Bruce Momjian | 1998-01-11 20:45:54 | Re: [HACKERS] Re: [BUGS] Some BUG-FIXES to postgreSQL on SCO 3.2v5.0.2 |