Re: Table Partitioning is in 8.1

On Thu, Sep 22, 2005 at 10:11:50AM +0100, Simon Riggs wrote:
> 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.

Actually, IIRC it takes 2 commands; one to initially setup the
partitioning and one to create new partitions as needed. 3 commands if
you count DROP PARTITON.

It's been a while since I looked at what you've done, but I seem to
recall needing to manually maintain rules every time you create a new
partition.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461