Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0FDB2632FB8 for ; Fri, 20 Mar 2009 17:29:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 75855-04 for ; Fri, 20 Mar 2009 17:29:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sp-exchfea.sp.corp.collab.net (sp-exchfea.sp.corp.collab.net [204.16.106.198]) by mail.postgresql.org (Postfix) with ESMTP id C40D6633B93 for ; Fri, 20 Mar 2009 17:29:07 -0300 (ADT) Received: from [204.11.125.145] ([204.11.125.145]) by sp-exchfea.sp.corp.collab.net with Microsoft SMTPSVC(6.0.3790.3959); Fri, 20 Mar 2009 13:29:04 -0700 Message-ID: <49C3FC8E.9070004@collab.net> Date: Fri, 20 Mar 2009 13:29:02 -0700 From: Anne Rosset User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alvaro Herrera CC: Robert Haas , Richard Huxton , pgsql-performance@postgresql.org Subject: Re: Need help with one query References: <49C2AC75.5060601@collab.net> <49C3600E.20504@archonet.com> <49C3CF52.9090602@collab.net> <603c8f070903201204s53f2a3cvbf9afc8649b2201a@mail.gmail.com> <20090320191453.GM8313@alvh.no-ip.org> In-Reply-To: <20090320191453.GM8313@alvh.no-ip.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-OriginalArrivalTime: 20 Mar 2009 20:29:04.0403 (UTC) FILETIME=[82F6A630:01C9A99A] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/302 X-Sequence-Number: 33224 Alvaro Herrera wrote: >Robert Haas escribió: > > > >>Something is wrong here. How can setting enable_seqscan to off result >>in a plan with a far lower estimated cost than the original plan? If >>the planner thought the non-seq-scan plan is cheaper, it would have >>picked that one to begin with. >> >> > >GEQO? Anne, what's geqo_threshold set to? > > > Hi Alvaro: It is turned off geqo | off | Enables genetic query optimization. Thanks, Anne