Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 57D549F9A0E for ; Sun, 7 Oct 2007 13:06:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 89660-05 for ; Sun, 7 Oct 2007 13:06:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web31802.mail.mud.yahoo.com (web31802.mail.mud.yahoo.com [68.142.207.65]) by postgresql.org (Postfix) with SMTP id 25B919F99F7 for ; Sun, 7 Oct 2007 13:06:39 -0300 (ADT) Received: (qmail 17979 invoked by uid 60001); 7 Oct 2007 16:06:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=zYL52QYGT8bUrouVp9bo9EKuo8lYP4uFNMx/h0A64aNaDgs88Z1n3iWKbXK8X30mcekLDiZepyNhB/KZlUjuuIUcmZjyv6TDrwA1kD3Bz5zIAKmbhpt5h8h4AKOcnSfQ4syi0jaO6yqDiFCfhbTM3LGVU9LjFX6EtadEakDcJtk=; X-YMail-OSG: sZPk8R4VM1mD_PQG3.Xy.gL8uKdvbmdzefaTYwGBFyhPb0uWpm4_MZluOmIIWuPvIRMkSApKQu_TtviE7Bs1PXHGeyRD4nOg6OUQMKHTqJpLd2E- Received: from [75.84.89.248] by web31802.mail.mud.yahoo.com via HTTP; Sun, 07 Oct 2007 09:06:37 PDT Date: Sun, 7 Oct 2007 09:06:37 -0700 (PDT) From: Richard Broersma Jr Subject: Re: query plan worse after analyze To: Stephen Frost , Jeff Frost Cc: 'PostgreSQL Performance' In-Reply-To: <20071006031438.GE5031@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <262364.17348.qm@web31802.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.364 tagged_above=0 required=5 tests=AWL=0.363, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200710/72 X-Sequence-Number: 27094 --- Stephen Frost wrote: > (perhaps a > pastebin like http://pgsql.privatepaste.com) instead of or in addition > to sending it in the email. It this new? I don't remember seeing this used before. Regards, Richard Broersma Jr.