X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B79BE5516A for ; Wed, 11 May 2005 18:27:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93574-03 for ; Wed, 11 May 2005 21:27:44 +0000 (GMT) Received: from priv-edtnes56.telusplanet.net (outbound01.telus.net [199.185.220.220]) by svr1.postgresql.org (Postfix) with ESMTP id C5A7F54C55 for ; Wed, 11 May 2005 18:27:43 -0300 (ADT) Received: from localhost ([199.185.220.240]) by priv-edtnes56.telusplanet.net (InterMail vM.6.01.04.04 201-2131-118-104-20050224) with ESMTP id <20050511212745.IYPR14487.priv-edtnes56.telusplanet.net@localhost> for ; Wed, 11 May 2005 15:27:45 -0600 Received: from 209.17.183.249 ( [209.17.183.249]) as user a3a18850@192.168.200.1 by webmail.telus.net with HTTP; Wed, 11 May 2005 14:27:45 -0700 Message-ID: <1115846865.428278d135357@webmail.telus.net> Date: Wed, 11 May 2005 14:27:45 -0700 From: Mischa Sandberg To: pgsql-performance@postgresql.org Subject: Re: Bad plan after vacuum analyze References: <42823F94.8050009@smet.org> In-Reply-To: <42823F94.8050009@smet.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1-cvs X-Originating-IP: 209.17.183.249 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.039 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200505/224 X-Sequence-Number: 12388 Quoting Guillaume Smet : > Hi, > > We have some performances problem on a particular query. ... I have to say it, this was the best laid-out set of details behind a problem I've ever seen on this list; I'm going to try live up to it, the next time I have a problem of my own.