Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BC6082E2F24 for ; Sun, 10 Feb 2008 00:34:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 87122-04 for ; Sun, 10 Feb 2008 00:33:58 -0400 (AST) Received: from mail.mailpen.net (mail.mailpen.net [209.90.228.14]) by postgresql.org (Postfix) with ESMTP id 844042E2ED7 for ; Sun, 10 Feb 2008 00:33:58 -0400 (AST) Received: from [172.24.2.1] (pool-71-113-24-134.sttlwa.dsl-w.verizon.net [71.113.24.134]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.mailpen.net (Postfix) with ESMTP id 66B782FE802 for ; Sat, 9 Feb 2008 20:33:57 -0800 (PST) Message-ID: <47AE7EC8.9040403@ultimeth.com> Date: Sat, 09 Feb 2008 20:34:16 -0800 From: "Dean Gibson (DB Administrator)" Organization: UltiMeth Systems User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: When to ANALYZE w/ auto-vacuum Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/120 X-Sequence-Number: 28194 Now, that I have 8.3.0 installed & running auto-vacuum, I have gotten rid of all my scripted VACUUMs, and I would like to get rid of all the scripted ANALYZEs as well. The 8.3 docs say: "In the default PostgreSQL configuration, /The Auto-Vacuum Daemon/ takes care of automatic analyzing of tables when they are first loaded with data, and as they change throughout regular operation." However: 1. There is one nightly process I run where I create a fairly large TEMP table (well over 1 million rows), and then I immediately use it in a subsequent SELECT. Would a scripted ANALYZE be really needed here, or does the auto-vacuum track the large TEMP table as I create it (via a single SELECT). 2. For that manner, do TEMP tables get higher priority in auto-vacuum runs? That would seem to be a good idea. -- Dean