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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
