Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 6BA1418B8E85 for ; Fri, 30 Mar 2012 04:20:48 -0300 (ADT) Received: from mail-bk0-f46.google.com ([209.85.214.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SDW8d-0003Zp-1L for pgsql-admin@postgresql.org; Fri, 30 Mar 2012 07:20:48 +0000 Received: by bkcik5 with SMTP id ik5so252887bkc.19 for ; Fri, 30 Mar 2012 00:20:33 -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:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=yBhOOQMpuEio77cpFy0bSJGyvA3uaXZ3hHWuJ3tC2pA=; b=eyMa9cuPEQCopLbEd4eHzuNR79cOP6MPqZK2TxwHLsx+XoIq7sQGlqwsqVL0usyfq5 gH2m5ZId1QJ6MC5uHPSlXpu1kUoj5kTHAoOWeL2zKaAbj4yifxOoSk8N6/JleVHVOnN7 NTgpv971mjj/of48iAPOSJvCnvYHkyQOzdupH+Tjes2ozqqjlNGTFck418MEkDzfM5gL LAVRr98o+cAthzWbJqEUYcjhQVVN4/5gNNbFX+UUzyUx1DlzCH8sTTpnQNvN7nW0aW5B 23nzEkuVnUAQI2NRfwA1ytPQgsVLBm1kc9GOr4uhgorIXJWgM4lqwYnrQuMGTHqHQulS 1rlQ== Received: by 10.204.156.139 with SMTP id x11mr485365bkw.59.1333092033508; Fri, 30 Mar 2012 00:20:33 -0700 (PDT) Received: from zeus.local (88-149-211-141.dynamic.ngi.it. [88.149.211.141]) by mx.google.com with ESMTPS id z17sm18625328bkw.12.2012.03.30.00.20.31 (version=SSLv3 cipher=OTHER); Fri, 30 Mar 2012 00:20:31 -0700 (PDT) Message-ID: <4F755EBE.2070908@gmail.com> Date: Fri, 30 Mar 2012 09:20:30 +0200 From: Alexander Fortin User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:11.0) Gecko/20120327 Thunderbird/11.0.1 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> <4F746282.3060406@innogames.de> In-Reply-To: <4F746282.3060406@innogames.de> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201203/136 X-Sequence-Number: 39324 On 3/29/12 3:24 PM, Bernhard Schrader wrote: > Hi, > > which filesystem do you use, and which kernel is running? Hi Bernhard, it's XFS on Ubuntu server 11.10, Kernel is 3.0.0-16-virtual (m1.large Ec2 instances) -- Alexander Fortin http://about.me/alexanderfortin/