Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 70AC2636238 for ; Tue, 20 Jul 2010 12:56:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 48961-03 for ; Tue, 20 Jul 2010 15:55:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.erwied.eu (mail.erwied.eu [85.214.80.157]) by mail.postgresql.org (Postfix) with ESMTP id 86F4D6362A9 for ; Tue, 20 Jul 2010 12:55:56 -0300 (ADT) Received: from dslb-088-078-096-210.pools.arcor-ip.net ([88.78.96.210] helo=erwied.dns2go.com ident=mail) by mail.erwied.eu with esmtpsa (Exim 4.72#1) id 1ObFAg-0006hB-17 for ; Tue, 20 Jul 2010 17:55:54 +0200 Received: from port-87-234-32-189.static.qsc.de ([87.234.32.189] helo=localhost) by erwied.dns2go.com with esmtpsa (Exim 4.72#1) id 1ObFAd-0007kA-Jv for ; Tue, 20 Jul 2010 17:55:51 +0200 Date: Tue, 20 Jul 2010 17:55:48 +0200 From: Jochen Erwied Organization: Creative Chaos Computing X-Priority: 3 (Normal) Message-ID: <928016768.20100720175548@erwied.eu> To: pgsql-performance@postgresql.org Subject: Re: dates and partitioning In-Reply-To: <201007200936.07736.cs_dba@consistentstate.com> References: <201007200936.07736.cs_dba@consistentstate.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15 Content-Transfer-Encoding: quoted-printable X-Antivirus: avast! (VPS 100720-0, 20.07.2010), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/291 X-Sequence-Number: 39680 Tuesday, July 20, 2010, 5:36:07 PM you wrote: > 2) the above query creates a plan that does a sequential scan & filter on= =20 > every partition. Why won't it only hit the correct partitions? Is it due = to > the way the date was specified? or maybe the "at time zone" syntax? Quick guess: How is your 'constraint_exclusion'-setting?=20 Which version of postgres? --=20 Jochen Erwied | home: jochen@erwied.eu +49-208-38800-18, FAX: -19 Sauerbruchstr. 17 | work: joe@mbs-software.de +49-2151-7294-24, FAX: -50 D-45470 Muelheim | mobile: jochen.erwied@vodafone.de +49-173-5404164