Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2C287632DAC for ; Tue, 16 Feb 2010 12:39:34 -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 24898-08 for ; Tue, 16 Feb 2010 16:39:22 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp2e.orange.fr (smtp2e.orange.fr [80.12.242.113]) by mail.postgresql.org (Postfix) with ESMTP id 303CD632D98 for ; Tue, 16 Feb 2010 12:39:23 -0400 (AST) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf2e23.orange.fr (SMTP Server) with ESMTP id A79BC800035D for ; Tue, 16 Feb 2010 17:39:20 +0100 (CET) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf2e23.orange.fr (SMTP Server) with ESMTP id 9ADB9800040B for ; Tue, 16 Feb 2010 17:39:20 +0100 (CET) Received: from [192.168.10.15] (ARennes-257-1-110-118.w86-210.abo.wanadoo.fr [86.210.21.118]) by mwinf2e23.orange.fr (SMTP Server) with ESMTP id 63CA2800035D for ; Tue, 16 Feb 2010 17:39:20 +0100 (CET) X-ME-UUID: 20100216163920408.63CA2800035D@mwinf2e23.orange.fr Message-ID: <4B7ACA37.1050908@boozter.com> Date: Tue, 16 Feb 2010 17:39:19 +0100 From: lionel duboeuf User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Almost infinite query -> Different Query Plan when changing where clause value References: <4B7A3F26020000250002F31A@gw.wicourts.gov> In-Reply-To: <4B7A3F26020000250002F31A@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201002/257 X-Sequence-Number: 37678 Thank you Kevin and Scott for all the explanations. ;-) regards Lionel