Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id BA6842AB7ED
	for <pgsql-admin@postgresql.org>; Fri, 17 Feb 2012 14:00:51 -0400 (AST)
Received: from cerberus.pinpointresearch.com ([66.7.238.130]
	helo=polaris.pinpointresearch.com)
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <scrawford@pinpointresearch.com>) id 1RyS70-0003IP-Ny
	for pgsql-admin@postgresql.org; Fri, 17 Feb 2012 18:00:51 +0000
Received: from betelgeuse.pinpointresearch.com
	(betelgeuse.pinpointresearch.com [192.168.1.179])
	by polaris.pinpointresearch.com (Postfix) with ESMTP id 388BAE00FC11;
	Fri, 17 Feb 2012 10:00:37 -0800 (PST)
Message-ID: <4F3E95C4.1060102@pinpointresearch.com>
Date: Fri, 17 Feb 2012 10:00:36 -0800
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.26) Gecko/20120131 Lightning/1.0b2 Thunderbird/3.1.18
MIME-Version: 1.0
To: Bernhard Schrader <bernhard.schrader@innogames.de>
CC: pgsql-admin@postgresql.org
Subject: Re: Big difference in databasesize compared with disksize
References: <4F3A6018.3000902@innogames.de> <4F3E246D.10900@innogames.de>
In-Reply-To: <4F3E246D.10900@innogames.de>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201202/78
X-Sequence-Number: 39138

On 02/17/2012 01:57 AM, Bernhard Schrader wrote:
> As result of no response i will try again and add some more 
> information for you.
>
> The given problem is the same. I have many DB's which have for unknown 
> reason, differences in Filesizes, if you check them with "du" or "ls", 
> in their Filenodes.
Since you are getting different results from the OS tools (ls, du) on an 
XFS system I'd check for info on XFS lists.

Googling "xfs du ls size difference" gives about 95,000 pages related to 
this issue.

Cheers,
Steve