X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D1B809FADD1 for ; Tue, 30 May 2006 14:41:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 89687-02 for ; Tue, 30 May 2006 14:41:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from alvh.no-ip.org (201-221-200-231.bk11-dsl.surnet.cl [201.221.200.231]) by postgresql.org (Postfix) with ESMTP id 2371D9FA5E9 for ; Tue, 30 May 2006 14:41:40 -0300 (ADT) Received: by alvh.no-ip.org (Postfix, from userid 1000) id 323C6C3A214; Tue, 30 May 2006 13:41:38 -0400 (CLT) Date: Tue, 30 May 2006 13:41:38 -0400 From: Alvaro Herrera To: Sriram Dandapani Cc: pgsql-admin@postgresql.org Subject: Re: pg_total_relation_size Message-ID: <20060530174137.GB31547@surnet.cl> Mail-Followup-To: Sriram Dandapani , pgsql-admin@postgresql.org References: <6992E470F12A444BB787B5C937B9D4DF04997644@ca-mail1.cis.local> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF04997644@ca-mail1.cis.local> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/421 X-Sequence-Number: 21953 Sriram Dandapani wrote: > Does the pg_total_relation_size take into account the free space map > /"yet to be vacuumed data" ? Both -- it measures the physical sizes of the files on disk, without looking at the contents. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.