Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 602BD6329FB for ; Wed, 31 Mar 2010 18:37:08 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 01404-01 for ; Wed, 31 Mar 2010 21:36:51 +0000 (UTC) X-Greylist: delayed 00:12:10.76199 by SQLgrey-1.7.6 Received: from winmail.eldocomp.com (winmail.eldocomp.com [205.159.99.12]) by mail.postgresql.org (Postfix) with ESMTP id 1EDD76328F0 for ; Wed, 31 Mar 2010 18:36:56 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.5 x-cr-puzzleid: {A9294801-175B-4A08-A025-B112572CBE26} MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable x-cr-hashedpuzzle: BB6/ Bf8i CAJa CS9i CdHm CiW1 C8B/ DKVz D6p2 ENbS E5FS FnHC GDvb Hl4F ISQy Jk7Y; 1; cABnAHMAcQBsAC0AYQBkAG0AaQBuAEAAcABvAHMAdABnAHIAZQBzAHEAbAAuAG8AcgBnAA==; Sosha1_v1; 7; {A9294801-175B-4A08-A025-B112572CBE26}; bgB3AGEAbABrAGUAcgBAAG0AaABzAC4AbQBwAGgAYQBzAGkAcwAuAGMAbwBtAA==; Wed, 31 Mar 2010 21:24:41 GMT; RgByAGUAZQAgAFMAcABhAGMAZQAgAGEAZgB0AGUAcgAgAHYAYQBjAHUAdQBtAGkAbgBnAA== Content-class: urn:content-classes:message Subject: Free Space after vacuuming Date: Wed, 31 Mar 2010 14:24:41 -0700 Message-ID: In-Reply-To: <20090420182602.GE10358@alvh.no-ip.org> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Free Space after vacuuming Thread-Index: AcnB5i2IO3cHDVsXQ8W/EGmewmTDO0PMdRbA References: <49ECBBD3.5060200@nasa.gov> <20090420182602.GE10358@alvh.no-ip.org> From: "Naomi Walker" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/293 X-Sequence-Number: 34092 All, How does one tell how much space is available (probably by table), after a=20 "vacuum verbose analyze" has completed. As I understand it, the emptied space will still be only available to the table that originally housed it. =20 We are running Postgresql 8.3 in various Solaris and Linux environments. Thanks, Naomi