Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 04E22632DB6 for ; Tue, 16 Feb 2010 12:47:55 -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 26738-03 for ; Tue, 16 Feb 2010 16:47:43 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp21.orange.fr (smtp21.orange.fr [80.12.242.48]) by mail.postgresql.org (Postfix) with ESMTP id 5DE38632D98 for ; Tue, 16 Feb 2010 12:47:44 -0400 (AST) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf2116.orange.fr (SMTP Server) with ESMTP id 50DCB1C01077 for ; Tue, 16 Feb 2010 17:47:42 +0100 (CET) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf2116.orange.fr (SMTP Server) with ESMTP id 429731C00FCF for ; Tue, 16 Feb 2010 17:47:42 +0100 (CET) Received: from [192.168.10.15] (ARennes-257-1-110-118.w86-210.abo.wanadoo.fr [86.210.21.118]) by mwinf2116.orange.fr (SMTP Server) with ESMTP id F313F1C01077 for ; Tue, 16 Feb 2010 17:47:41 +0100 (CET) X-ME-UUID: 20100216164741995.F313F1C01077@mwinf2116.orange.fr Message-ID: <4B7ACC2D.7000405@boozter.com> Date: Tue, 16 Feb 2010 17:47:41 +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> <4B7ACA37.1050908@boozter.com> In-Reply-To: <4B7ACA37.1050908@boozter.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit 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/258 X-Sequence-Number: 37679 lionel duboeuf a écrit : > Thank you Kevin and Scott for all the explanations. ;-) > > regards > Lionel > > > Sorry for forgetting Jorge also. regards. All this ,encourage me to know more about database management.