Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id DA9CB1810A03 for ; Fri, 2 Mar 2012 15:31:18 -0400 (AST) Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S3YCB-0008O8-Sz for pgsql-performance@postgresql.org; Fri, 02 Mar 2012 19:31:16 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q22JV1kj010496; Fri, 2 Mar 2012 14:31:01 -0500 (EST) To: "McGehee, Robert" cc: "pgsql-performance@postgresql.org" Subject: Re: Inefficient min/max against partition (ver 9.1.1) In-reply-to: <17B09E7789D3104E8F5EEB0582A8D66FBAA3FCEDC0@MSGRTPCCRF2WIN.DMN1.FMR.COM> References: <17B09E7789D3104E8F5EEB0582A8D66FBAA3FCEDC0@MSGRTPCCRF2WIN.DMN1.FMR.COM> Comments: In-reply-to "McGehee, Robert" message dated "Wed, 29 Feb 2012 12:32:32 -0500" Date: Fri, 02 Mar 2012 14:31:00 -0500 Message-ID: <10495.1330716660@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/42 X-Sequence-Number: 46492 "McGehee, Robert" writes: > On PostgreSQL 9.1.1, I'm experiencing extremely slow/inefficient > min/max queries against a partitioned table, despite the recent > improvements made in version 9.1. Thanks for the report. I believe this will fix it: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ef03b34550e3577c4be3baa25b70787f5646c57b regards, tom lane