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 A87035280C for ; Wed, 17 Aug 2005 15:59:18 -0300 (ADT) 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 90310-04 for ; Wed, 17 Aug 2005 18:59:15 +0000 (GMT) Received: from smtp4.gtdinternet.com (smtp4.gtdinternet.com [200.75.0.34]) by svr1.postgresql.org (Postfix) with ESMTP id 12DB352AEA for ; Wed, 17 Aug 2005 15:59:07 -0300 (ADT) Received: from telsur.com (correo4.gtdinternet.com [200.75.0.12]) by smtp4.gtdinternet.com (Postfix) with ESMTP id BFDC26BD71; Wed, 17 Aug 2005 15:00:09 -0400 (CLT) Received: from correo4.gtdinternet.com(200.75.0.12) by av1.gtdinternet.com via smtp id 6f0d_01a792c4_0f51_11da_8be4_0002b3ebca3b; Wed, 17 Aug 2005 14:59:16 -0400 Received: from alvh.no-ip.org [200.85.218.206] by telsur.com with ESMTP (SMTPD32-8.15) id A8F3CD3011A; Wed, 17 Aug 2005 14:58:59 -0400 Received: from 200-85-218-206.bk4-dsl.surnet.cl(200.85.218.206) by av1.gtdinternet.com via smtp id 6e6f_00a933e6_0f51_11da_914d_0002b3ebca3b; Wed, 17 Aug 2005 14:59:14 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id B54DAC2DC2A; Wed, 17 Aug 2005 14:59:37 -0400 (CLT) Date: Wed, 17 Aug 2005 14:59:37 -0400 From: Alvaro Herrera To: D Kavan Cc: pgsql-admin@postgresql.org Subject: Re: vacuumdb -a -f Message-ID: <20050817185937.GE26491@alvh.no-ip.org> Mail-Followup-To: D Kavan , pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.713 required=5 tests=[AWL=0.289, DNS_FROM_RFC_ABUSE=0.374, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/230 X-Sequence-Number: 18549 On Wed, Aug 17, 2005 at 02:15:42PM -0400, D Kavan wrote: > > 'du -h' in the base directory. > > >How are you finding out the DB size? You are considering the difference in XLog segment size, right? The pg_xlog directory may start almost empty and then start filling. The space will not be recovered by any maintenance command. -- Alvaro Herrera () Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí." "Y que hayan abogados, para que la gente no culpe de todo a Satanás"