Re: Feature suggestions (long)

Matthew Kirkwood wrote:

>On Sat, 17 May 2003, Alvaro Herrera wrote:
>
>  
>
>>>>I'm going suggest a feature like what Oracle calls "partitions" and later on
>>>>something with indexes. The idea is to generate some discussion to see if
>>>>they are worthy of being added to the TODO list.
>>>>        
>>>>
>>>Why bother?
>>>      
>>>
>>Maybe one can put different partitions in different tablespaces?
>>    
>>
>
>One can.  The tablespace a partition is in can even be
>offline if Oracle can prove that a query doesn't require
>that partition.
>  
>

Being able to "segment" tables for admin purposes (like archiving) might 
be beneficial.

I guess this could be orthogonal to clustering or partitioning schemes 
that mininize table/index access for queries.

(Oracle has sort of rolled these ideas together with their partitioning)

Mark