Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 31A172E0038 for ; Fri, 4 Apr 2008 22:26:42 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 50651-06 for ; Fri, 4 Apr 2008 22:26:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from oxford.xeocode.com (87-127-95-198.no-dns-yet.enta.net [87.127.95.198]) by developer.postgresql.org (Postfix) with ESMTP id BC0362E002D for ; Fri, 4 Apr 2008 22:26:39 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.69) (envelope-from ) id 1JhxAy-0004NB-5S; Sat, 05 Apr 2008 02:26:36 +0100 To: "kevin kempter" Cc: Subject: Re: Partitioned tables - planner wont use indexes In-Reply-To: (kevin kempter's message of "Fri\, 4 Apr 2008 18\:48\:25 -0600") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 5044) References: From: Gregory Stark Organization: EnterpriseDB Date: Sat, 05 Apr 2008 02:26:36 +0100 Message-ID: <87myo9drcj.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/48 X-Sequence-Number: 29541 "kevin kempter" writes: > that the planner wants to do a sequential scan on each partition. We do have > "constraint_elimination = on" set in the postgresql.conf file. "constraint_exclusion" btw. > myDB=# explain SELECT min(logdate) FROM part_master; Er, yeah. Unfortunately this is just not a kind of query our planner knows how to optimize when dealing with a partitioned table... yet. There are several different pieces missing to make this work. There's some hope some of them might show up for 8.4 but no guarantees. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support!