On Saturday 17 May 2003 10:51 am, 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.
People use this feature for warehousing old data that they don't want to purge
from the database. For very large databases (of course that definition
changes with each new generation of computer) this can greatly improve the
performance of queries on the active portion of the data.