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

Auto Partitioning Patch - WIP version 1

From: NikhilS <nikkhils(at)gmail(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Auto Partitioning Patch - WIP version 1
Date: 2007-03-30 06:58:02
Message-ID: d3c4af540703292358s8ed731el7771ab14083aa610@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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: auto-partition-v1.0.patch
Description: text/x-patch (16.8 KB)

Responses

pgsql-hackers by date

Next:From: Zdenek KotalaDate: 2007-03-30 07:16:30
Subject: Re: Crash bug in 8.2.3 on Solaris 10/Sparc
Previous:From: Pavan DeolaseeDate: 2007-03-30 06:14:38
Subject: Re: CREATE INDEX and HOT - revised design

pgsql-patches by date

Next:From: Zeugswetter Andreas ADI SDDate: 2007-03-30 08:22:23
Subject: Re: [PATCHES] Full page writes improvement, code update
Previous:From: Koichi SuzukiDate: 2007-03-30 04:02:52
Subject: Re: [PATCHES] Full page writes improvement, code update

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