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