Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9E41B633B75 for ; Mon, 4 Jan 2010 17:32:21 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 82123-01-9 for ; Mon, 4 Jan 2010 21:32:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.iplink.net (smtp.iplink.net [192.139.81.186]) by mail.postgresql.org (Postfix) with ESMTP id 44069634352 for ; Mon, 4 Jan 2010 17:28:27 -0400 (AST) Received: from [10.255.0.247] (fw.iplink.net [192.139.81.98]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.iplink.net (Postfix) with ESMTP id 0AEA18C0D94; Mon, 4 Jan 2010 16:28:26 -0500 (EST) Message-ID: <4B425D79.7010302@alteeve.com> Date: Mon, 04 Jan 2010 16:28:25 -0500 From: Madison Kelly User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Kevin Grittner Cc: Gary Doades , pgsql-performance@postgresql.org Subject: Re: DB is slow until DB is reloaded References: <4B423D22.7040803@alteeve.com> <4B424215.70605@pinpointresearch.com> <4B424FF6.40207@alteeve.com> <4B425222.7070905@gpdnet.co.uk> <4B425555.6020709@alteeve.com> <4B420354020000250002DCC4@gw.wicourts.gov> In-Reply-To: <4B420354020000250002DCC4@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.189 tagged_above=-10 required=5 tests=BAYES_50=0.001, FH_DATE_PAST_20XX=3.188 X-Spam-Level: *** X-Archive-Number: 201001/16 X-Sequence-Number: 36896 Kevin Grittner wrote: > Madison Kelly wrote: > >> I've added CLUSTER -> ANALYZE -> VACUUM to my nightly >> routine and dropped the VACUUM FULL call. > > The CLUSTER is probably not going to make much difference once > you've eliminated bloat, unless your queries do a lot of searches in > the sequence of the index used. Be sure to run VACUUM ANALYZE as > one statement, not two separate steps. > > -Kevin Ah, noted and updated, thank you. Madi