Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 267AB9F9CCC for ; Thu, 16 Nov 2006 14:13:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 31742-10 for ; Thu, 16 Nov 2006 14:13:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id B3F1A9F9998 for ; Thu, 16 Nov 2006 14:13:49 -0400 (AST) Received: from D1RPQZB1 ([192.168.1.181]) (authenticated) by mail.autorevenue.com (8.11.6/8.11.6) with ESMTP id kAGIDlc15339; Thu, 16 Nov 2006 13:13:47 -0500 From: "Mark Steben" To: "'Simon Riggs'" Cc: Subject: Re: Question on partitioning Date: Thu, 16 Nov 2006 13:13:38 -0500 Message-ID: <002601c709aa$f06ca210$b501a8c0@D1RPQZB1> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <1163698723.27956.554.camel@silverbirch.site> X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Thread-index: AccJpiF3HuzJT99KTv+G3uYhzXpQYAABGxFA X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/164 X-Sequence-Number: 23691 Simon, you're right on the money.. the guys on the IRC chatroom suggested that I cast the partitioning column as SMALLINT as the optimizer assumed Integer and it worked. Thx for getting back to me Mark Steben AutoRevenue -----Original Message----- From: Simon Riggs [mailto:simon@2ndquadrant.com] Sent: Thursday, November 16, 2006 12:39 PM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Question on partitioning On Wed, 2006-11-15 at 15:13 -0500, Mark Steben wrote: > Regarding partitioning - I set up a testing table - parent table and 4 > partitioning children's tables inheriting the > > Attributes of the parent. I inserted 1800 rows in all - 450 equitably > in each partition. The CHECK constraints work great. > > The PART_ID column, defined as SMALLINT, Is the partitioning > column. > You'll probably want to look at the caveats here http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html#DDL-PARTITIO NING-CAVEATS especially the ones about cross-datatype comparisons in CHECK constraints. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com