Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A2E426334ED for ; Fri, 20 Mar 2009 21:38:02 -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 29910-05 for ; Fri, 20 Mar 2009 21:37:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by mail.postgresql.org (Postfix) with ESMTP id 3BC9A632465 for ; Fri, 20 Mar 2009 21:37:53 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c5so821712anc.28 for ; Fri, 20 Mar 2009 17:37:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=x9Mr4RKlDE29ec4UGQ70B0wMuJaRdwS+9IdRwNvv6r0=; b=dkOht0jciJKDdzUM/0WH+MTPuYQokXpfKt09a774kIk9e0y/gP07838OKhq9ZfwVxr CngTINqQIhFCiqSxHQmmtOB3TQBgO7NQGJW+fepQ3zjyrB61TPCKAWlp8oogmXuiRo77 n1COz4SC7bB/KQVVPGRauPxTUpiGsoy1McVps= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=bqW35c/n0gMAdskVDjub8NyjKC+4groluBMVeRc+yLDY243FwQOxkR73mgZZwy6LSP JSCpGZBEaJH8L7JYuYaFVI3Kl4w0S1fi4vElp7pXvtQemRFKeQPOqFMapcvi/lE3NB7t iNZrJ7E15LXmxljQrtr90pFLyr48XXvWvMnV0= MIME-Version: 1.0 Received: by 10.101.70.14 with SMTP id x14mr4540544ank.131.1237595872295; Fri, 20 Mar 2009 17:37:52 -0700 (PDT) In-Reply-To: <49C3FC8E.9070004@collab.net> References: <49C2AC75.5060601@collab.net> <49C3600E.20504@archonet.com> <49C3CF52.9090602@collab.net> <603c8f070903201204s53f2a3cvbf9afc8649b2201a@mail.gmail.com> <20090320191453.GM8313@alvh.no-ip.org> <49C3FC8E.9070004@collab.net> Date: Fri, 20 Mar 2009 20:37:52 -0400 Message-ID: <603c8f070903201737u7543a26w62f265d2352318f5@mail.gmail.com> Subject: Re: Need help with one query From: Robert Haas To: Anne Rosset Cc: Alvaro Herrera , Richard Huxton , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.124 tagged_above=0 required=5 tests=AWL=0.124 X-Spam-Level: X-Archive-Number: 200903/312 X-Sequence-Number: 33234 On Fri, Mar 20, 2009 at 4:29 PM, Anne Rosset wrote: > Alvaro Herrera wrote: >> Robert Haas escribi=F3: >>> Something is wrong here. =A0How can setting enable_seqscan to off resul= t >>> in a plan with a far lower estimated cost than the original plan? =A0If >>> the planner thought the non-seq-scan plan is cheaper, it would have >>> picked that one to begin with. >>> >> >> GEQO? =A0Anne, what's geqo_threshold set to? > Hi Alvaro: > It is turned off > geqo | off | Enables genetic query optimization. > Thanks, > Anne Can you please send ALL your non-commented postgresql.conf lines? ...Robert