From: Sean Davis <sdavis2@mail.nih.gov>
To: Richard Huxton <dev@archonet.com>
Cc: 'PostgreSQL' <pgsql-sql@postgresql.org>
Cc: dpandey@secf.com
Subject: Re: Table PARTITION
Date: Thu, 7 Apr 2005 08:16:16 -0400
Message-ID: <e5f9c6fea13bb95521003dbdb65ad5f2@mail.nih.gov> (raw)
In-Reply-To: <42552244.5050603@archonet.com>
References: <20050407114136.17B7E53AA5@svr1.postgresql.org>
<42552244.5050603@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sdavis2@mail.nih.gov, dev@archonet.com, dpandey@secf.com
Subject: Re: Table PARTITION
In-Reply-To: <e5f9c6fea13bb95521003dbdb65ad5f2@mail.nih.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox