Re: Table Partitioning is in 8.1 - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Table Partitioning is in 8.1
Date
Msg-id 1127380311.4145.98.camel@localhost.localdomain
Whole thread Raw
In response to Re: Table Partitioning is in 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Table Partitioning is in 8.1
Re: Table Partitioning is in 8.1
Re: Table Partitioning is in 8.1
List pgsql-hackers
On Wed, 2005-09-21 at 15:39 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.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




pgsql-hackers by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs
Next
From: "Michael Paesold"
Date:
Subject: Re: Parser bug results in ambiguous errors/behaviour