Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2C51D9FB322 for ; Fri, 10 Nov 2006 12:30:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 36718-10 for ; Fri, 10 Nov 2006 12:30:04 -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 4E10A9FB323 for ; Fri, 10 Nov 2006 12:30:03 -0400 (AST) Received: from D1RPQZB1 ([192.168.1.181]) (authenticated) by mail.autorevenue.com (8.11.6/8.11.6) with ESMTP id kAAGU2c23829 for ; Fri, 10 Nov 2006 11:30:02 -0500 From: "Mark Steben" To: "'Mark Steben'" , Subject: Question on partitioning Date: Fri, 10 Nov 2006 11:29:55 -0500 Message-ID: <003201c704e5$74fb5a00$b501a8c0@D1RPQZB1> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0033_01C704BB.8C255200" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Thread-Index: AccCqcHaI3PfJ+Y0QnKYwm679EOHcwCOiO6g In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/107 X-Sequence-Number: 23634 This is a multi-part message in MIME format. ------=_NextPart_000_0033_01C704BB.8C255200 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Thanks to all who responded to my question on querying on cluster index names. I have another question. We are considering partitioning 2 or 3 of our larger tables. Each has 12 million or more rows. We want to partition on customer_id and build Primary key indexes on each of the children partitions which inherit column characteristics