Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5FB841337C22 for ; Wed, 6 Apr 2011 12:41:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 05069-03-7 for ; Wed, 6 Apr 2011 15:41:45 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ndmsnpf03.ndc.nasa.gov (ndmsnpf03.ndc.nasa.gov [198.117.0.123]) by mail.postgresql.org (Postfix) with ESMTP id 5420E1337C41 for ; Wed, 6 Apr 2011 12:37:42 -0300 (ADT) Received: from ndmsppt05.ndc.nasa.gov (ndmsppt05.ndc.nasa.gov [198.117.0.104]) by ndmsnpf03.ndc.nasa.gov (Postfix) with ESMTP id B7365180233; Wed, 6 Apr 2011 10:37:29 -0500 (CDT) Received: from ndmshub01.ndc.nasa.gov (ndmshub01-pub.ndc.nasa.gov [198.117.0.160]) by ndmsppt05.ndc.nasa.gov (8.14.4/8.14.4) with ESMTP id p36FbTaI006119; Wed, 6 Apr 2011 10:37:29 -0500 Received: from lrc000959195.larc.nasa.gov (198.119.134.170) by smtp02.ndc.nasa.gov (198.117.0.160) with Microsoft SMTP Server (TLS) id 8.3.137.0; Wed, 6 Apr 2011 10:37:29 -0500 Message-ID: <4D9C88B8.6000205@nasa.gov> Date: Wed, 6 Apr 2011 11:37:28 -0400 From: "Maria L. Wilson" Reply-To: Organization: SSAI User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9 MIME-Version: 1.0 To: Kevin Grittner CC: Szymon Guz , "Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS AND APPLICATIONS, INC]" , "pgsql-performance@postgresql.org" Subject: Re: help speeding up a query in postgres 8.4.5 References: <4D9B6CBA.2050609@nasa.gov> <4D9C6BA6.4070305@nasa.gov> <4D9C4182020000250003C3AB@gw.wicourts.gov> In-Reply-To: <4D9C4182020000250003C3AB@gw.wicourts.gov> Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.2.15, 1.0.148, 0.0.0000 definitions=2011-04-06_05:2011-04-06, 2011-04-06, 1970-01-01 signatures=0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/72 X-Sequence-Number: 43134 yep - we use analyze and check the output. It's version 8.4.5 so no fsm issues. thanks, Maria On 4/6/11 11:33 AM, Kevin Grittner wrote: > "Maria L. Wilson" wrote: > >> Autovacuum is not running - but regular vacuums are being done >> twice daily. > > Is the ANALYZE keyword used on those VACUUM runs? What version of > PostgreSQL is this. If it's enough to need fsm settings, do you run > with the VERBOSE option and check the end of the output to make sure > they are set high enough? > > -Kevin