Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B3B8F9FB5A3 for ; Mon, 5 Mar 2007 12:11:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 94783-05 for ; Mon, 5 Mar 2007 12:11:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 40D4F9FB4D9 for ; Mon, 5 Mar 2007 12:11:21 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l25GB8kx019107; Mon, 5 Mar 2007 11:11:08 -0500 (EST) To: "Bruce McAlister" cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL 8.2.3 VACUUM Timings/Performance In-reply-to: References: Comments: In-reply-to "Bruce McAlister" message dated "Mon, 05 Mar 2007 12:33:18 +0000" Date: Mon, 05 Mar 2007 11:11:08 -0500 Message-ID: <19106.1173111068@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.061 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/92 X-Sequence-Number: 23497 "Bruce McAlister" writes: > [1] AutoVacuum runs during the day over the entire PostgreSQL cluster, Good, but evidently you need to make it more aggressive. > [2] A Vacuum Full Verbose is run during our least busy period (generally > 03:30) against the Database, > [3] A Re-Index on the table is performed, > [4] A Cluster on the table is performed against the most used index, > [5] A Vacuum Analyze Verbose is run against the database. That is enormous overkill. Steps 2 and 3 are a 100% waste of time if you are going to cluster in step 4. Just do the CLUSTER and then ANALYZE (or VACUUM ANALYZE if you really must, but the value is marginal). regards, tom lane