Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id BCB59D6F1EA for ; Thu, 29 Mar 2012 07:41:27 -0300 (ADT) Received: from mail-ee0-f46.google.com ([74.125.83.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SDCnG-000882-Rz for pgsql-admin@postgresql.org; Thu, 29 Mar 2012 10:41:27 +0000 Received: by eekc41 with SMTP id c41so912907eek.19 for ; Thu, 29 Mar 2012 03:41:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=oROdRONMciraZc/yDgvagPlxjevxE5Bibcza58zab5U=; b=q8v/uuXLsAOXW9YI1Vy/cnH1Fn8AKx9y7Hsr4H+AVBnlbOcv8Dx57oJDZx3NOacpaD kiJxr/Fo+Zo0Fp/H43RqKpw1heAMiGZQL87KYUV60WOU69OzqHXSG7ZZAlk/rCkk9RNm qqkn2JDJcG7Hb20SUYvdFB3A25Vx1deyIaDzIVN9zaJOjTBhDcw6kfa6lUUn5J3FhDUz qWGd6TLERWGeAueWoaZw2opCJ/HRPr+nhy9SW3KVupj4aY+6yRkmXKjKCL/thPiIkJl7 wnu7LdPEVc/4OkSF4Un6f57isdg2PLoBLNqiFgqp0LidBLMTHkzLCBNbkMG0+bVnAxXL +Xqw== Received: by 10.180.107.104 with SMTP id hb8mr4398554wib.8.1333017673579; Thu, 29 Mar 2012 03:41:13 -0700 (PDT) Received: from zeus.local (88-149-211-141.dynamic.ngi.it. [88.149.211.141]) by mx.google.com with ESMTPS id ea6sm35698826wib.5.2012.03.29.03.41.12 (version=SSLv3 cipher=OTHER); Thu, 29 Mar 2012 03:41:12 -0700 (PDT) Message-ID: <4F743C47.1040907@gmail.com> Date: Thu, 29 Mar 2012 12:41:11 +0200 From: Alexander Fortin User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:11.0) Gecko/20120313 Thunderbird/11.0 MIME-Version: 1.0 To: Raghavendra CC: pgsql-admin@postgresql.org Subject: Re: pg_database_size() and actual disk space usage References: <4F742D3A.8010501@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201203/132 X-Sequence-Number: 39320 On 3/29/12 11:41 AM, Raghavendra wrote: > Can you also tell what replication is in place ? Sure thing, it's Postgresql 9.1.2, master + two replicas in streaming replication hot standby -- Alexander Fortin http://about.me/alexanderfortin/