Re: Big difference in databasesize compared with disksize

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Bernhard Schrader <bernhard(dot)schrader(at)innogames(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Big difference in databasesize compared with disksize
Date: 2012-02-17 18:00:36
Message-ID: 4F3E95C4.1060102@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2012-02-17 21:00:51 Re: Out of memory...
Previous Message Cassiano, Marco 2012-02-17 15:41:52 Out of memory...