Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 6B005D6F1F2 for ; Thu, 29 Mar 2012 10:24:44 -0300 (ADT) Received: from extern.innogames.de ([80.252.99.240]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SDFLG-0002MQ-Qa for pgsql-admin@postgresql.org; Thu, 29 Mar 2012 13:24:43 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by extern.innogames.de (Postfix) with ESMTP id ACD0C28E325 for ; Thu, 29 Mar 2012 15:24:27 +0200 (CEST) Received: from extern.innogames.de ([127.0.0.1]) by localhost (extern.innogames.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0EGjH8detzDZ for ; Thu, 29 Mar 2012 15:24:27 +0200 (CEST) Received: from [172.16.5.29] (unknown [212.48.107.10]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by extern.innogames.de (Postfix) with ESMTPSA id BA7CC28E323 for ; Thu, 29 Mar 2012 15:24:19 +0200 (CEST) Message-ID: <4F746282.3060406@innogames.de> Date: Thu, 29 Mar 2012 15:24:18 +0200 From: Bernhard Schrader User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:11.0) Gecko/20120310 Thunderbird/11.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: pg_database_size() and actual disk space usage References: <4F742D3A.8010501@gmail.com> <4F743C47.1040907@gmail.com> In-Reply-To: <4F743C47.1040907@gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/133 X-Sequence-Number: 39321 On 03/29/2012 12:41 PM, Alexander Fortin wrote: > 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 > Hi, which filesystem do you use, and which kernel is running? regards