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 4E3BA56581 for ; Wed, 16 Mar 2005 18:04:07 +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 78480-03 for ; Wed, 16 Mar 2005 18:04:04 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id EC003565AB for ; Wed, 16 Mar 2005 18:04:03 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 16 Mar 2005 12:04:01 -0600 Subject: Re: Vacuum questions From: Scott Marlowe To: Chris Hoover Cc: Tom Lane , pgsql-admin@postgresql.org In-Reply-To: <42387328.9090806@sermonaudio.com> References: <423749C1.2030803@sermonaudio.com> <3243.1110958068@sss.pgh.pa.us> <42387328.9090806@sermonaudio.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1110996240.28555.189.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 16 Mar 2005 12:04:01 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/250 X-Sequence-Number: 16748 On Wed, 2005-03-16 at 11:55, Chris Hoover wrote: > 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)??? the table