Re: [HACKERS] Alternate locations for databases
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
Import Notes
Reply to msg id not found: 345D3DA6.BF225BE7@alumni.caltech.edu
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
Show quoted text
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.
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! _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_