Re: Table Partitioning is in 8.1

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Table Partitioning is in 8.1
Date: 2005-09-22 09:11:50
Message-ID: 1127380311.4145.98.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2005-09-21 at 15:39 -0400, Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> > Is it possible that the Release Notes do not fully explain the
> > Constraint Exclusion feature? Or is it the consensus that it works but
> > not quite well enough to make a song and dance about yet?
>
> I hardly think that the existing constraint-exclusion code is enough for
> us to claim we "support table partitioning". There's too much grunt
> work that the DBA still has to do to set up a partitioning arrangement.

So you think the DBA can do partitioning? Good.

Setting up partitioning in Oracle or SQLServer2005 requires lots of
syntax and multiple commands. There are fewer commands with PostgreSQL
and they are ISO/ANSI compliant also.

I think there is much still left to do with partitioning, so I would be
the first to say that this is only the beginning. I know you are wary of
overstating capabilities; so am I, but it looks like we differ slightly
on where to draw the line.

On reflection, the only changes I suggest are:

1) the phrase "This allows for a type of table partitioning" have the
word "basic" inserted within it to become: "This allows for a basic type
of table partitioning"

2) placing CE as a major feature of 8.1 - many people regard it at least
as highly as other optimizations, though this is subjective based upon
their application requirements

Suggestion (2) might be seen as some kind of vanity, so having raised
the issue I'll leave the floor open to others to agree or not.

Best Regards, Simon Riggs

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paesold 2005-09-22 10:01:47 Re: Parser bug results in ambiguous errors/behaviour
Previous Message Michael Glaesemann 2005-09-22 07:15:26 Re: Minimally avoiding Transaction Wraparound in VLDBs