Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 58CC52E3509 for ; Fri, 11 Jan 2008 13:42:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 22732-04 for ; Fri, 11 Jan 2008 13:42:17 -0400 (AST) Received: from mailhub.ikv.de (mailhub.ikv.de [62.145.4.19]) by postgresql.org (Postfix) with ESMTP id 50E132E3335 for ; Fri, 11 Jan 2008 13:42:17 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by mailhub.ikv.de (Postfix) with ESMTP id 3D66A2FC014 for ; Fri, 11 Jan 2008 18:42:14 +0100 (CET) Received: from mailhub.ikv.de ([192.168.200.65]) by localhost (mailhub.ikv.de [192.168.200.65]) (amavisd-new, port 10024) with ESMTP id 06781-10 for ; Fri, 11 Jan 2008 18:42:14 +0100 (CET) Received: from [192.168.100.225] (unknown [192.168.100.225]) by mailhub.ikv.de (Postfix) with ESMTP id 04F362FC00E for ; Fri, 11 Jan 2008 18:42:13 +0100 (CET) Message-ID: <4787AA75.5090102@ikv.de> Date: Fri, 11 Jan 2008 18:42:13 +0100 From: =?ISO-8859-1?Q?J=F6rg_Kiegeland?= User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Evaluating boolean formula: slow performance References: <4787A1FB.2050808@ikv.de> In-Reply-To: <4787A1FB.2050808@ikv.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at ikv.de X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200801/73 X-Sequence-Number: 28312 I have to correct my statement, a query seems to be only linear when using OR. This however is strange since some weeks ago, I could get good response times when using exclusively AND. I will investigate on this..