X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F018D3A47DF for ; Fri, 12 Nov 2004 18:39:30 +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 79723-07 for ; Fri, 12 Nov 2004 18:39:28 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 93AA83A4784 for ; Fri, 12 Nov 2004 18:39:26 +0000 (GMT) Received: from [64.81.245.111] (account josh@agliodbs.com HELO temoku.sf.agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6650757 for pgsql-performance@postgresql.org; Fri, 12 Nov 2004 10:40:55 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Clarification on two bits on VACUUM FULL VERBOSE output Date: Fri, 12 Nov 2004 10:42:02 -0800 User-Agent: KMail/1.6.2 MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Message-Id: <200411121042.02759.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/191 X-Sequence-Number: 9145 Folks, Wanted to get clarification on two bits of output from 7.4's VACUUM FULL VERBOSE: "Total free space (including removable row versions) is 2932036 bytes." If the table referenced has no dead row versions, does this indicate open space on partially full pages? "There were 33076 unused item pointers." Is this a count of dead index pointers, or something else? -- --Josh Josh Berkus Aglio Database Solutions San Francisco