Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 5903AC24695 for ; Fri, 30 Dec 2011 13:50:29 -0400 (AST) Received: from rsx35.justhost.com ([184.154.21.218]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rggb4-00008F-Mq for pgsql-performance@postgresql.org; Fri, 30 Dec 2011 17:50:29 +0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=tactis.pt; h=Received:Message-ID:Disposition-Notification-To:Date:From:Reply-To:Organization:User-Agent:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding:X-Source:X-Source-Args:X-Source-Dir; b=RJscfXbQzoh8oUcMnBSRrFIWLfQClMohWC/B4C4kmISf3i+hDbGWqLYP2AacJSeA13lsXgp4vve+kDFX0dr7rX8vttbyF0ejcgpdNtD2oJsOIXYFWV9Xs7ayxsDJkWEa; Received: from 195-23-29-173.static.net.novis.pt ([195.23.29.173] helo=[192.168.70.15]) by rsx35.justhost.com with esmtpa (Exim 4.69) (envelope-from ) id 1Rggap-0006zb-1p; Fri, 30 Dec 2011 11:50:11 -0600 Message-ID: <4EFDF9D0.4040107@tactis.pt> Date: Fri, 30 Dec 2011 17:50:08 +0000 From: Miguel Silva Reply-To: miguel.silva@tactis.pt Organization: TACTIS , LDA User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: Tom Lane CC: pgsql-performance@postgresql.org Subject: Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards References: <4EFDE928.50807@tactis.pt> <19327.1325266819@sss.pgh.pa.us> In-Reply-To: <19327.1325266819@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - rsx35.justhost.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - tactis.pt X-Source: X-Source-Args: X-Source-Dir: X-Pg-Spam-Score: -2.0 (--) X-Archive-Number: 201112/210 X-Sequence-Number: 46009 On 30-12-2011 17:40, Tom Lane wrote: > Miguel Silva writes: >> But with postgresql version 9.0.5 (in version 9.0.4 all was fine), we >> noticed the program was taking longer to start. In fact, in some clients >> that had older hardware, it could take around 20 minutes when it usually >> takes only a few seconds. To make a long story short, the problem was >> traced and narrowed down to a single auto generated query. Here it is: >> "SELECT [ snip ]" >> ... Here are the explain analyzes. >> enable_material ON: http://explain.depesz.com/s/wen >> enable_material OFF: http://explain.depesz.com/s/Zaa > It doesn't really accomplish anything to post anonymized explain output > when you've already shown us the actual query, does it? Especially when > said query involves only the system catalogs and by no stretch of the > imagination could be thought to contain anything proprietary? > > regards, tom lane > Indeed you are right. Those are explains I created some time ago, when I didn't really know what that webpage did. I just kept them, and used them now, didn't even think about that. But the explains are still there, still useful. Anyway, if it is really necessary, I can post new ones. Best regards, Miguel Silva