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

Re: Auto Partitioning Patch - WIP version 1

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: NikhilS <nikkhils(at)gmail(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: Auto Partitioning Patch - WIP version 1
Date: 2008-03-21 14:00:11
Message-ID: 1206108011.4285.666.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Fri, 2007-03-30 at 12:28 +0530, NikhilS wrote:

> 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 think this patch is a reasonable first step and clearly written, but
not yet ready for application to Postgres in this commit fest.

I would say we need:

* Clear explanation of the new syntax, with examples of each permutation
so we can see how that would work. In light of recent discussions on
-hackers we need to take a view on whether we should go with Gavin's
suggested syntax or this syntax.

* There are some additional syntax items I don't understand the need
for. So these need to be explained.

* I would be against using the term PARTITION BY since it is already a
phrase that is part of the SQL Standard. Perhaps PARTITIONED BY?

* We need regression tests for any new command syntax

* No docs - that might be the same thing as the first item

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com 

  PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk


In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2008-03-21 14:06:06
Subject: Re: Commit Fest (was Re: Sort Refinement)
Previous:From: Bruce MomjianDate: 2008-03-21 12:48:49
Subject: Re: Commit Fest (was Re: Sort Refinement)

pgsql-patches by date

Next:From: Tatsuo IshiiDate: 2008-03-21 14:38:29
Subject: Re: Proposal: new large object API
Previous:From: Brendan JurdDate: 2008-03-21 04:09:25
Subject: Re: [PATCHES] Show INHERIT in \du

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