Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 55FA79F926B for ; Tue, 6 Nov 2007 20:19:23 -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 20253-05 for ; Tue, 6 Nov 2007 20:18:46 -0400 (AST) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id CE1A89F9266 for ; Tue, 6 Nov 2007 20:19:18 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id f5so1507160nfh for ; Tue, 06 Nov 2007 16:19:17 -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=T5vArq2TqtjWZTKL2lGtZanrJk0DGJ/gJoJgn0rlwSA=; b=MTLdDidtIflq/RzRtyzcR3rzOMTfCTvGmzF39KlaN7KYbmS0yY6+viyLFV8ypDjMXlhke7tV0NgkWOAcr3cb8HP+tMrItO1Qf7Pcs8om8Sptf0LWc6WHW5idM4Z5GRXbTZZh0J06paAksMm1HqGcHJP+iuUfMrGDWv3OM1PzjM4= 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=f4lRXfHY/lsYg1KYi8xAQDCqY+j6o9vWu50+gQlgfSEIajJCa3gr1rF4jTGNgY5j4ZGeFWHhK7Mk7s0ggq7MygZ1D3KK8ObcIpwtIzyoL5JNwr+BpObhOpi709zWyz1JqTgyYnpV32PEkRtdRCpTj12y8c/DIJdp1eua9aW0gR0= Received: by 10.78.165.16 with SMTP id n16mr5468556hue.1194394756702; Tue, 06 Nov 2007 16:19:16 -0800 (PST) Received: by 10.78.137.18 with HTTP; Tue, 6 Nov 2007 16:19:16 -0800 (PST) Message-ID: <9da20ce20711061619r7dde0f50ke547e766cac2634e@mail.gmail.com> Date: Tue, 6 Nov 2007 19:19:16 -0500 From: "j a" To: "Scott Marlowe" Subject: Re: Vacuum Doesn't Recover Disk Space Cc: pgsql-admin@postgresql.org In-Reply-To: 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/60 X-Sequence-Number: 27303 Thanks for the tip. I probably should've waited for vacuum to actually finish instead of cancelling it prematurely (thinking PG Admin was finished). On Nov 6, 2007 12:42 PM, Scott Marlowe wrote: > > 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. >