
just change the work tablespace below to location and that is exactly
what this patch is trying to do.  You can think of the LOCATION and
INDEX_LOCATION provided to the create database command as the default
storage locations for these objects.  In the future, I want to enable
the DBA to specify LOCATIONS any object just like Oracle.  I am also
planning on a pg_locations table and "create location" command which
will do what the current initlocation script does and more.


Jim


> 
> I am very new to this mailinglist so I apologize if I start talking
early but
> I've been working as a sysadmin and that kind of problems for a long
while
> now and my suggestion is that it is a start but I think that we should
aim a
> little higher than this and use something more like the Oracle
approach
> instead. Where they introduce an abstraction layer in the form of a
> tablespace. And this tablespace is then referenced from the create
table or
> create index instead.
> eg:
> table -> tablespace -> path to physical storage
> index -> tablespace -> path to physical storage
> 
> Advantages:
> Changes can be done to storage whithout need to change create scripts
for db,
> tables and so on.
> Designers can specify in which tablespace tables/indexes should reside
based
> on usage.
> Sysadmins can work with tablespaces and change paths without changing
> anything in the database/table/index definitions.
> 
> The alternative is symlinks to distribute the load and that is not a
pretty
> sight dba-wise.
> 
> Hope you can bare with me on this, since I think it is an very
important
> issue.
> I'm unfortunately not a fast coder yet (but I'm getting faster :-) ).
But I
> could start writing a spec if someone is interrested.
> 
> Bruce Momjian wrote:
> 
> > > Hi all,
> > >
> > > Attached is a patch that adds support for specifying a location 
for
> > > indexes via the "create database" command.
> > >
> > > I believe this patch is complete, but it is my first .
> >
> > This patch allows index locations to be specified as different from
data
> > locations.  Is this a feature direction we want to go in?  Comments?
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
19026
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://www.postgresql.org/search.mpl
> 
> 
> ---------------------------(end of
broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
> 
> 



Wed, 12 Sep 2001 14:25:54 -0400
"Jim Buttafuoco" <jim@buttafuoco.net>
Re: Index location patch for review