Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0BCB89FA61D for ; Fri, 10 Nov 2006 13:39:24 -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 61756-03 for ; Fri, 10 Nov 2006 13:39:18 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31803.mail.mud.yahoo.com (web31803.mail.mud.yahoo.com [68.142.207.66]) by postgresql.org (Postfix) with SMTP id E719B9FA1E2 for ; Fri, 10 Nov 2006 13:39:17 -0400 (AST) Received: (qmail 28644 invoked by uid 60001); 10 Nov 2006 17:39:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Am5Pk1nZ3gh4nOVfyf24r8xSU8l16P4BpmFwFaPArNUgfvUIYBV4djh8D6bS5NkkHC1VT02P7QRuMGhtE+Isdhv98tXM7TBYFFhprkImFTlG4nNJeVBJ6JhoYHM7vnx2mRoxB976DBLCkHzhULe6Zge/ogPecvEOCAeoEdAL83U= ; X-YMail-OSG: CiesjHgVM1lM1g7Ek9UDPOJbdkIavJw6DCA3jLple6D7JlX0POBISXSYwzOcSSt2b6Ppprf2.EM0OcB28zLFy9iMNmB23h2vWJWOpSQVk8.xK.uVMZp0yOb7hbeHHXd7QRGWH_MfVzv0J5SalvaJAb13XtixQSeCnrlKALzazJ496d1iD55msj9gicw. Received: from [12.177.97.50] by web31803.mail.mud.yahoo.com via HTTP; Fri, 10 Nov 2006 09:39:16 PST Date: Fri, 10 Nov 2006 09:39:16 -0800 (PST) From: Richard Broersma Jr Subject: Re: Question on partitioning To: Mark Steben , pgsql-admin@postgresql.org In-Reply-To: <003201c704e5$74fb5a00$b501a8c0@D1RPQZB1> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <129402.28483.qm@web31803.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.353 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200611/108 X-Sequence-Number: 23635 > 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 > From the master table. This would resolve any issues about queries on > customer-id. > My question is this: How would I handle a query that queries > On another Non-partitioned column, say, ENTRY_DATE? Could I design an index > On the master table that would reference ENTRY-DATE across partitions or > will > I need to build indexes and queries on each partition? I haven't done too much partitioning yet, but this is where I would start looking first: http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html Regards, Richard Broersma Jr.