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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly