Re: Table PARTITION

This is a totally selfish question, but IF someone has a few minutes, 
could he/she explain why table partitioning is such an important tool?

Thanks,
Sean

On Apr 7, 2005, at 8:06 AM, Richard Huxton wrote:

> Dinesh Pandey wrote:
>> How can we create oracle's table with partition in Postgres. (How to 
>> create
>> Table partion in postgres)
>> CREATE TABLE invoices
>> (invoice_no    NUMBER NOT NULL,  invoice_date  DATE   NOT NULL,
>>  comments      VARCHAR2(500))
>> PARTITION BY RANGE (invoice_date)
>> (PARTITION invoices_q1 VALUES LESS THAN (TO_DATE('01/04/2001',
>> 'DD/MM/YYYY')) TABLESPACE users
>
> By hand, I'm afraid (although I think people are looking into this 
> feature for version 8.1)
>
> There's lots of discussion in the mail archives about how people are 
> handling this. You're basically looking at some combination of
>  - partial/conditional indexes
>  - unions
>  - inheritance
>
> --
>   Richard Huxton
>   Archonet Ltd
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly