Skip site navigation (1) Skip section navigation (2)

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: 2007-04-26 23:08:22
Message-ID: 200704262308.l3QN8MU02077@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
This has been saved for the 8.4 release:

	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://www.enterprisedb.com

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

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-04-26 23:20:07
Subject: Re: Implicit casts to text
Previous:From: Bruce MomjianDate: 2007-04-26 22:51:58
Subject: Re: Interaction of PITR backups and Bulkoperationsavoiding WAL

pgsql-patches by date

Next:From: Bruce MomjianDate: 2007-04-26 23:09:57
Subject: Re: Preliminary GSSAPI Patches
Previous:From: Tom LaneDate: 2007-04-26 19:42:58
Subject: Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group