X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BDDD656712 for ; Wed, 16 Mar 2005 17:55:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73451-09 for ; Wed, 16 Mar 2005 17:55:12 +0000 (GMT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id 8DA4856599 for ; Wed, 16 Mar 2005 17:55:10 +0000 (GMT) thread-index: AcUqUZqIf330L3+ZTvejDpwrccnR4g== Received: from [10.4.13.50] ([66.194.26.150]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.211); Wed, 16 Mar 2005 12:57:22 -0500 Message-ID: <42387328.9090806@sermonaudio.com> Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Date: Wed, 16 Mar 2005 12:55:52 -0500 From: "Chris Hoover" User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Tom Lane" Cc: Subject: Re: Vacuum questions References: <423749C1.2030803@sermonaudio.com> <3243.1110958068@sss.pgh.pa.us> In-Reply-To: <3243.1110958068@sss.pgh.pa.us> Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 16 Mar 2005 17:57:22.0281 (UTC) FILETIME=[9A814D90:01C52A51] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/249 X-Sequence-Number: 16747 Tom, Thanks so much for the possible reason the vacuum fulls are not running. But, how about the first question. When you run a vacuum , who has access to the freed tuples? (only the table, the db, or the entire cluster)??? Thanks, Chris