Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BE9C09F929C for ; Tue, 6 Nov 2007 13:42:46 -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 21290-03 for ; Tue, 6 Nov 2007 13:42:12 -0400 (AST) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id 8B2E19F9265 for ; Tue, 6 Nov 2007 13:42:04 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id j3so1167635ugf for ; Tue, 06 Nov 2007 09:42:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=V/0uFmBYjry3o14DNarqxmLFCsS7EN3RU9TP3tApy2U=; b=RWFRCl+WTDEGYDckgdPWKvFVrqyss0Af1fYxEVBD3kTTDUOPgfWjm1wC1cgX5ykXZwMFQrMiqctxalK5mID1Tl9J1vKC5/kMvKGculXKVDnEvCCNhOhAKLwy8dMTBYUyFrdGctdKIWCgxiSdVNm26tNbvwbGFt0Aq/CA3MFlwxk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UoRD2kUq6aJV+OdywgWsq+4JhUfSFhy8U0YW3tQVHkgcXZuIXmu4XXVa4PYwobQ/+5N/N891vbGHtdWLaRWFD1cL1xvmTLpg1cOfqVpvAtoHGsOmGlxMgY0hU5c+GeSlDdv3jGlvml0Q1ZN0UkNyHnoxUtA5wmGJHbAOIOczFoo= Received: by 10.67.32.14 with SMTP id k14mr3806086ugj.1194370923029; Tue, 06 Nov 2007 09:42:03 -0800 (PST) Received: by 10.67.40.10 with HTTP; Tue, 6 Nov 2007 09:42:02 -0800 (PST) Message-ID: Date: Tue, 6 Nov 2007 11:42:02 -0600 From: "Scott Marlowe" To: "j a" Subject: Re: Vacuum Doesn't Recover Disk Space Cc: pgsql-admin@postgresql.org In-Reply-To: <9da20ce20711060936q16611447o9b00da179533846b@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <9da20ce20711060936q16611447o9b00da179533846b@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/57 X-Sequence-Number: 27300 On 11/6/07, j a wrote: > I have a large table that I remove around 10m rows from every 2 months. I > try running Vacuum Full w/Analyze (both boxes checked in PG Admin), but the > disk space is never returned to the system. Any way I can force this? > > I'm running 7.4 on CentOS4.3 You likely have index bloat. try reindexing.