Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 6CBFA159076 for ; Mon, 5 Mar 2012 11:44:49 -0400 (AST) Received: from mx01.clickware.de ([78.35.13.85]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1S4a5g-0003Ey-1M for pgsql-performance@postgresql.org; Mon, 05 Mar 2012 15:44:48 +0000 Received: (qmail 17098 invoked by uid 1010); 5 Mar 2012 15:44:33 -0000 Received: from localhost (marc@localhost) by mx01 (envelope-from , uid 1002) with qmail-scanner-2.06st (sophie: //. spamassassin: 3.2.3. Clear:RC:0(127.0.0.1):SA:0(-2.8/5.0):. Processed in 0.082955 secs); 05 Mar 2012 15:44:33 -0000 X-Spam-Status: No, hits=-2.8 required=5.0 Received: from localhost (HELO ?192.168.1.220?) (marc@127.0.0.1) by mx01.clickware.de with SMTP; 5 Mar 2012 15:44:33 -0000 Message-ID: <4F54DF61.6000007@clickware.de> Date: Mon, 05 Mar 2012 16:44:33 +0100 From: Marc Schablewski User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2 MIME-Version: 1.0 To: Tomas Vondra CC: pgsql-performance@postgresql.org Subject: Re: Partitioning / Strange optimizer behaviour References: <4F54D785.6090200@clickware.de> <552209dfaffc4a1d6934fd5bcf6c5907.squirrel@sq.gransy.com> In-Reply-To: <552209dfaffc4a1d6934fd5bcf6c5907.squirrel@sq.gransy.com> X-Enigmail-Version: 1.3.5 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/56 X-Sequence-Number: 46506 Thanks for pointing me to that article. I totally forgot that the postgres wiki existed. Updating is not an option at the moment, but we'll probably do so in the future. Until then I can live with the workaround. Kind regards, Marc