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

From: "Nikhil Sontakke" <nikhil(dot)sontakke(at)enterprisedb(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>, "Emmanuel Cecchet" <manu(at)frogthinker(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1
Date: 2008-11-27 14:01:27
Message-ID: a301bfd90811270601wb7d0cc3k397328d109b54dd7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi,

>
> > The status has always being WIP, because what has not happened is that we
> > have not had consensus on whether this is a logical first baby step ahead
> > with partitioning. I haven't seen core members commenting on whether
> trying
> > to aggregate the current set of manual operations together via this
> approach
> > is worth spending further efforts, to get it into commitable shape.
>
> There was a lenghty, interesting discussion about this topic in the
> developer meeting in Ottawa.
>
> http://wiki.postgresql.org/wiki/PgCon_2008_Developer_Meeting#Partitioning_Roadmap
>

The discussion is indeed interesting. But again the notes do not indicate
any broad consensus on the roadmap :).

The current inheritance based mechanism has its pros-cons and there seem to
be a multitude of requests/expectations around partitioning from different
quarters. Even basic consensus about the syntax is missing. What we need is
a step-by-step approach (starting with fixing up the syntax - if it can be
done like that) and working our way downwards towards the underlying
representation/planning for partitions...

Regards,
Nikhils
--
http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2008-11-27 14:01:56 Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1
Previous Message Andrew Chernow 2008-11-27 13:43:32 Re: Thread safety

Browse pgsql-patches by date

  From Date Subject
Next Message Jaime Casanova 2008-11-27 14:01:56 Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1
Previous Message Gregory Stark 2008-11-27 13:31:04 Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1