Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-02-17 21:00:51
Subject: Re: Out of memory...
Previous:From: Cassiano, MarcoDate: 2012-02-17 15:41:52
Subject: Out of memory...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group