Re: Table spaces again [was Re: Threaded Sorting]

Jim Buttafuoco wrote:

>Is this NOT what I have been after for many months now.  I dropped the tablespace/location idea before 7.2 because
that
>didn't seem to be any interest.  Please see my past email's for the SQL commands and on disk directory layout I have
>proposed.  I have a working 7.2 system with tablespaces/locations (what ever you want to call them,  I like locations
>because tablespace are an Oracle thing).  I would like to get this code ported into 7.4.
>
>Jim
>
>
>  
>
>>Hans-Jürgen Schönig <postgres@cybertec.at> writes:
>>    
>>
>>>how would you handle table spaces?
>>>      
>>>
>>The plan that's been discussed simply defines a tablespace as being a
>>directory somewhere; physical storage of individual tables would remain
>>basically the same, one or more files under the containing directory.
>>
>>The point of this being, of course, that the DBA could create the
>>tablespace directories on different partitions or volumes in order to
>>provide the behavior he wants.
>>
>>In my mind this would be primarily a cleaner, more flexible
>>reimplementation of the existing "database location" feature.
>>
>>            
>>

wow :)
can we have the patch? i'd like to try it with my 7.2.2 :).
is it stable?

how did you implement it precisely? is it as you have proposed it?
   Hans


-- 
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at 
<http://cluster.postgresql.at>, www.cybertec.at 
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>