From:
"Robert Haas" <robertmhaas(at)gmail(dot)com>
To:
"Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
Cc:
"Emmanuel Cecchet" <manu(at)frogthinker(dot)org>, "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-11-27 04:09:46
Message-ID:
603c8f070811262009v459d0701w151c16533d4ab947@mail.gmail.com (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
> i review it on nov 6, and there were open questions by me and by
> Emmanuel none of those has been answered:
> http://archives.postgresql.org/pgsql-hackers/2008-11/msg00362.php
Hmm, there's only one actual question in that email, which is a
request for ideas about PL/pgsql vs. C. I suspect you didn't get any
responses because the rest of the email seems to indicate that the
patch is not very mature at this point: for example, being able to
handle updates that move rows between partitions would seem to me to
be an essential feature for a project of this type, even though there
are many practical scenarios were it's unimportant. Likewise, being
able to repartition sounds important.
With respect to the specific question about PL/pgsql vs C, I suspect
it's very unlikely that any patch of this type that relies on PL/pgsql
being loaded would be accepted into core. However, it's possible that
a useful contrib module or pgfoundry project could be spawned on that
basis, and that might be a good place to start.
I think having a useful toolkit, or a core language feature, that
supports table partitioning would be awesome and would find very broad
application... but it sounds like there is quite a bit of work left
to be done to get there.
...Robert
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2008-11-27 04:15:19Subject : Re: where is the last hot standby patch?Previous :From : Hitoshi HaradaDate : 2008-11-27 03:21:40Subject : Re: Windowing Function Patch Review -> Standard Conformance
pgsql-patches by date
Next :From: Nikhil SontakkeDate: 2008-11-27 09:06:16Subject : Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1Previous :From : Jaime CasanovaDate : 2008-11-27 00:13:42Subject : Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1
