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:
2007-03-30 06:58:02 from NikhilS <nikkhils(at)gmail(dot)com>
2007-04-03 15:36:10 from NikhilS <nikkhils(at)gmail(dot)com>
2007-04-04 12:20:53 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-04 13:19:56 from NikhilS <nikkhils(at)gmail(dot)com>
2007-04-04 14:21:29 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-04 20:55:54 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2007-04-04 20:59:38 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-04-05 08:29:35 from NikhilS <nikkhils(at)gmail(dot)com>
2007-04-05 09:03:59 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-04-05 11:05:31 from NikhilS <nikkhils(at)gmail(dot)com>
2007-04-05 11:28:16 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-04-05 12:13:26 from NikhilS <nikkhils(at)gmail(dot)com>
2007-04-04 13:42:51 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-04-04 14:03:51 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-04-04 14:51:30 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-04 18:06:50 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-04-04 18:55:26 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-04 19:01:45 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-04-04 19:10:01 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-04-04 19:34:03 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-05 08:10:29 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-04-05 20:00:37 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-05 21:03:08 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-04-06 05:56:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-06 07:11:18 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-04-06 07:40:48 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-04-06 16:22:55 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-04-06 17:07:57 from David Fetter <david(at)fetter(dot)org>
2007-04-06 17:12:59 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-04-06 19:02:48 from Richard Troy <rtroy(at)ScienceTools(dot)com>
2007-04-06 10:47:46 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-04-06 13:09:19 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-04-06 19:26:54 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-04-06 14:39:16 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-04-04 20:29:08 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-04-05 01:17:00 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-04-05 15:15:42 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2007-04-04 19:40:31 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-05 15:24:08 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-04-05 16:29:27 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-04 14:07:39 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-04-04 16:43:28 from David Fetter <david(at)fetter(dot)org>
2007-04-04 19:26:44 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-04-04 19:41:34 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-04 20:05:55 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-04-04 20:30:12 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-04 14:31:54 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-04 15:07:51 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-04-04 16:33:05 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-04-26 23:08:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-03-21 14:00:11 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-03-21 14:45:43 from NikhilS <nikkhils(at)gmail(dot)com>
2008-03-21 15:18:41 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-03-21 15:53:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-03-22 05:19:01 from NikhilS <nikkhils(at)gmail(dot)com>
2008-03-21 17:01:35 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-10-22 14:44:46 from "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
2008-10-22 21:49:53 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-10-23 12:41:41 from "Nikhil Sontakke" <nikhil(dot)sontakke(at)enterprisedb(dot)com>
2008-10-31 14:50:46 from "Nikhil Sontakke" <nikhil(dot)sontakke(at)enterprisedb(dot)com>
2008-10-31 18:42:00 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-11-06 04:47:29 from "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
2008-11-26 21:35:23 from "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
2008-11-26 21:52:06 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-11-27 00:13:42 from "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
2008-11-27 04:09:46 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-11-27 09:06:16 from "Nikhil Sontakke" <nikhil(dot)sontakke(at)enterprisedb(dot)com>
2008-11-27 12:04:03 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-11-27 13:07:51 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-11-27 13:31:04 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-11-27 14:41:04 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-11-27 15:10:38 from "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
2008-11-27 15:12:13 from "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
2008-11-27 16:09:43 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-02 22:52:07 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-10 00:51:05 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-15 17:49:08 from Josh Berkus <josh(at)agliodbs(dot)com>
2008-12-15 18:46:43 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-12-15 19:01:19 from "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
2008-12-16 02:05:16 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-16 06:35:11 from "Nikhil Sontakke" <nikhil(dot)sontakke(at)enterprisedb(dot)com>
2008-12-16 07:13:29 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-16 07:02:17 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2008-12-16 07:33:36 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-16 07:58:49 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2008-12-16 08:19:31 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-16 17:17:02 from Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl>
2008-11-27 16:38:39 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-11-27 14:01:56 from "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
2008-11-27 14:47:27 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-11-27 14:01:27 from "Nikhil Sontakke" <nikhil(dot)sontakke(at)enterprisedb(dot)com>
2009-01-06 17:19:59 from Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
2008-03-21 16:53:44 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-03-26 00:55:42 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-03-26 12:31:15 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-03-26 13:34:26 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-03-26 13:42:02 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-03-26 13:48:40 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-03-26 13:54:46 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-03-26 14:05:53 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers pgsql-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
In response to
Responses
pgsql-hackers by date
Next :From: UnicronDate: 2008-12-10 01:02:59Subject : A question for the patch "blooming filter"Previous :From : Andrew DunstanDate : 2008-12-10 00:32:33Subject : Re: parallel restore vs. windows
pgsql-patches by date
Next :From: Teodor SigaevDate: 2008-12-12 17:36:55Subject : Re: [PATCHES] GIN improvementsPrevious :From : Heikki LinnakangasDate : 2008-12-03 16:40:17Subject : Re: [PATCHES] GIN improvements
