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@candle.pha.pa.us

Sun, 11 Jan 1998 15:48:39 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Alternate locations for databases
> Just checking to make sure this properly documented for 6.3 beta.  Is
> it?

man initlocationman create_database

Of course, it is not _properly_ documented. I haven't yet absorbed the man page
info into the new html/postscript docs, and may not be able to in time for v6.3.
Will see if anyone volunteers to help.

                                          - Tom

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


Mon, 12 Jan 1998 04:57:55 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] Alternate locations for databases
On Mon, 12 Jan 1998, Thomas G. Lockhart wrote:

> > Just checking to make sure this properly documented for 6.3 beta.  Is
> > it?
> 
> man initlocationman create_database
> 
> Of course, it is not _properly_ documented. I haven't yet absorbed the man page
> info into the new html/postscript docs, and may not be able to in time for v6.3.
> Will see if anyone volunteers to help.

I am familiar with a utility man2html that creates html from man pages.
I would be happy to do this as you folks wish (although I'm not
sure it's a great help).

Marc Zuckman
marc@fallon.classyad.com

_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
_     Visit The Home and Condo MarketPlace		      _
_          http://www.ClassyAd.com			      _
_							      _
_  FREE basic property listings/advertisements and searches.  _
_							      _
_  Try our premium, yet inexpensive services for a real	      _
_   selling or buying edge!				      _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_


Mon, 12 Jan 1998 21:59:31 -0500 (EST)
Marc Howard Zuckman <marc@fallon.classyad.com>
Re: [HACKERS] Alternate locations for databases