"Leaking" disk space

[Matthew Seaman]

On 20/03/2013 15:23, Dan Thomas wrote:
> Hi Guys,
> 
> We're seeing a problem with some of our FreeBSD/PostgreSQL servers
> "leaking" quite significant amounts of disk space:
> 
>     > df -h /usr/local/pgsql/
>     Filesystem       Size    Used   Avail Capacity  Mounted on
>     /dev/mfid1s1d    1.1T    772G    222G    78%    /usr/local/pgsql
> 
>     > du -sh /usr/local/pgsql/
>     741G    /usr/local/pgsql/
> 
> Stopping Postgres doesn't fix it, but rebooting does which points at
> the OS rather than PG to me. However, the leak is only apparent in the
> dedicated pgsql partition, and only on our database servers, so
> PostgreSQL seems to at least be involved. The partition itself is a
> relatively standard UFS partition:

Hi, Dan

You're not the first person to report that.  Please see the thread:

"leaking lots of unreferenced inodes (pg_xlog files?), maybe after
moving tables and indexes to tablespace on different volume"

on the freebsd-fs at freebsd.org mailing list.

Kirk McKusick was investigating the original report: CC'd.

	Cheers,

	Matthew