In-Reply-To: <42552244.5050603@archonet.com>
References: <20050407114136.17B7E53AA5@svr1.postgresql.org>
	<42552244.5050603@archonet.com>
Mime-Version: 1.0 (Apple Message framework v619.2)
Content-Type: text/plain; charset=US-ASCII; format=flowed
Message-Id: <e5f9c6fea13bb95521003dbdb65ad5f2@mail.nih.gov>
Content-Transfer-Encoding: 7bit
Cc: "'PostgreSQL'" <pgsql-sql@postgresql.org>, dpandey@secf.com
From: Sean Davis <sdavis2@mail.nih.gov>
Subject: Re: Table PARTITION
Date: Thu, 7 Apr 2005 08:16:16 -0400
To: Richard Huxton <dev@archonet.com>

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