Re: Auto Partitioning Patch - WIP version 1

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: NikhilS <nikkhils(at)gmail(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Auto Partitioning Patch - WIP version 1
Date: 2008-03-26 00:55:42
Message-ID: 200803260055.m2Q0tgw24740@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


This has been saved for the next commit-fest:

http://momjian.postgresql.org/cgi-bin/pgpatches_hold

---------------------------------------------------------------------------

NikhilS wrote:
> Hi,
>
> Please find attached the WIP version 1 of the auto partitioning patch. There
> was discussion on this a while back on -hackers at:
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg00375.php
>
> Please note that this patch tries to automate the activities that currently
> are carried out manually. It does nothing fancy beyond that for now. There
> were a lot of good suggestions, I have noted them down but for now I have
> tried to stick to the initial goal of automating existing steps for
> providing partitioning.
>
> Things that this patch does:
>
> i) Handle new syntax to provide partitioning:
>
> CREATE TABLE tabname (
> ...
> ) PARTITION BY
> RANGE(ColId)
> | LIST(ColId)
> (
> PARTITION partition_name CHECK(...),
> PARTITION partition_name CHECK(...)
> ...
> );
>
> ii) Create master table.
> iii) Create children tables based on the number of partitions specified and
> make them inherit from the master table.
>
> The following things are TODOs:
>
> iv) Auto generate rules using the checks mentioned for the partitions, to
> handle INSERTs/DELETEs/UPDATEs to navigate them to the appropriate child.
> Note that checks specified directly on the master table will get inherited
> automatically.
> v) Based on the PRIMARY, UNIQUE information specified, pass it on to the
> children tables.
> vi) [stretch goal] Support HASH partitions
>
> Will try to complete the above mentioned TODOs as soon as is possible.
>
> Comments, feedback appreciated.
>
> Thanks and Regards,
> Nikhils
> --
>
> EnterpriseDB http://www.enterprisedb.com

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2008-03-26 01:03:18 Re: writing a MIN(RECORD) aggregate
Previous Message Heikki Linnakangas 2008-03-26 00:32:25 Re: advancing snapshot's xmin

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2008-03-26 01:21:36 Script binaries renaming
Previous Message Tom Lane 2008-03-26 00:03:50 Re: Moving snapshot code around