Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0CACD6325C4 for ; Mon, 8 Mar 2010 13:25:10 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 67529-01 for ; Mon, 8 Mar 2010 17:24:58 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound-mail-359.bluehost.com (outbound-mail-359.bluehost.com [66.147.249.253]) by mail.postgresql.org (Postfix) with SMTP id EE1BA63233A for ; Mon, 8 Mar 2010 13:24:58 -0400 (AST) Received: (qmail 11680 invoked by uid 0); 8 Mar 2010 17:24:58 -0000 Received: from unknown (HELO box498.bluehost.com) (66.147.242.98) by oproxy1.bluehost.com.bluehost.com with SMTP; 8 Mar 2010 17:24:57 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=consistentstate.com; h=Received:From:Organization:To:Subject:Date:User-Agent:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-Id:X-Identified-User; b=EZF6xRT/35ZIsCEMAC7NATt10WgJ3YIj/f21KxOf6AQuTeRHU2n2+otg5vGoElbrzyOkqRX4zS5meFGjJkhqmEDbjsNM2QrRkpoEP9xCMXA49BzDglIs4MMaocf5Pbnk; Received: from c-67-176-12-8.hsd1.co.comcast.net ([67.176.12.8] helo=issac.consistentstate.com) by box498.bluehost.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1NoghN-0002Yn-O2 for pgsql-performance@postgresql.org; Mon, 08 Mar 2010 10:24:57 -0700 From: Kevin Kempter Organization: Consistent State To: pgsql-performance@postgresql.org Subject: prepared statements and partitioning (partition elimination not working) Date: Mon, 8 Mar 2010 10:24:56 -0700 User-Agent: KMail/1.13.0 (Linux/2.6.31.12-174.2.22.fc12.x86_64; KDE/4.4.0; x86_64; ; ) MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Message-Id: <201003081024.56840.kevink@consistentstate.com> X-Identified-User: {3049:box498.bluehost.com:consist3:consistentstate.com} {sentby:smtp auth 67.176.12.8 authed with kevink+consistentstate.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.933 tagged_above=-10 required=5 tests=AWL=-0.349, BAYES_20=-0.74, SUBJECT_FUZZY_TION=0.156 X-Spam-Level: X-Archive-Number: 201003/72 X-Sequence-Number: 37897 Hi all; we've found that partition elimination is not happening for a prepared statement, however running the same statement in psql manually does give us partition elimination. Is this a known issue?