Disk usage in postgresql 8.1.4

From: Geoff Parker <geoffparkernews(at)yahoo(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Disk usage in postgresql 8.1.4
Date: 2006-08-06 23:42:47
Message-ID: 20060806234247.10519.qmail@web57210.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I've got a database with about 155GB of binary data, however when I run the unix utility df, it reports only 60GB of disk space is being used. I've extracted random samples of data from the database, and it all appears correct, so I presume it's not corrupt. Can anyone tell me whether there's some sort of disk compression happening with large objects?

Has anyone else seen this behaviour?

# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup01-ATV_PGSQL
480678616 59285468 396976076 13% /var/lib/pgsql

This is Postresql version 8.1.4 on a slightly modified version of RHEL 4 (2.6.17 kernel).

Thanks,
Geoff.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Amadeus Zilfinski 2006-08-07 01:01:22 Re: running PostGres without installing it
Previous Message Aaron Bono 2006-08-06 20:13:59 Re: running PostGres without installing it