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

Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1

From: Emmanuel Cecchet <manu(at)frogthinker(dot)org>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, Gregory Stark <stark(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Nikhil Sontakke <nikhil(dot)sontakke(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1
Date: 2008-12-10 00:51:05
Message-ID: 493F1279.8010804@frogthinker.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Hi all,

While I was trying to find the right place to add a new page on the 
wiki, I found the document of Simon on partitioning requirements 
(http://wiki.postgresql.org/wiki/Image:Partitioning_Requirements.pdf) 
referenced from http://wiki.postgresql.org/wiki/Development_projects
I think  this is a good base to start from. Should we convert the doc 
into a wiki page or get the source for the doc and go from there?

I attach what I have come up with so far for the C trigger I was talking 
about for efficient automatic auto-partitioning of inserts in child tables.

Emmanuel

Robert Haas wrote:
> On Thu, Nov 27, 2008 at 11:09 AM, Emmanuel Cecchet <manu(at)frogthinker(dot)org> wrote:
>   
>> I have been following that discussion very closely but it seems that we are
>> debating solutions without a good specification of the problem/requirements.
>> I would suggest that we collect all the partitioning requirements on a
>> dedicated Wiki page. There might not be a one size fits it all solution for
>> all requirements. We can also look at what other databases are proposing to
>> address these issues.
>> If we can prioritize features, that should also allow us to stage the
>> partitioning implementation.
>>     
>
> This might be a good idea.  Want to take a crack at it?
>
>   
>> I have a prototype insert trigger in C that directly move inserts in a
>> master table to the appropriate child table (directly moving the tuple). Let
>> me know if anyone is interested.
>>     
>
> Can't hurt to post it.
>
> ...Robert
>
>   


-- 
Emmanuel Cecchet
FTO @ Frog Thinker 
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: manu(at)frogthinker(dot)org
Skype: emmanuel_cecchet


Attachment: patch-trigger-autopartition-C.txt
Description: text/plain (10.2 KB)

In response to

Responses

pgsql-hackers by date

Next:From: UnicronDate: 2008-12-10 01:02:59
Subject: A question for the patch "blooming filter"
Previous:From: Andrew DunstanDate: 2008-12-10 00:32:33
Subject: Re: parallel restore vs. windows

pgsql-patches by date

Next:From: Teodor SigaevDate: 2008-12-12 17:36:55
Subject: Re: [PATCHES] GIN improvements
Previous:From: Heikki LinnakangasDate: 2008-12-03 16:40:17
Subject: Re: [PATCHES] GIN improvements

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