X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DFDE59FB262 for ; Sun, 6 Aug 2006 20:49:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 03218-06 for ; Sun, 6 Aug 2006 20:49:29 -0300 (ADT) X-Greylist: delayed 00:06:39.370569 by SQLgrey- Received: from web57210.mail.re3.yahoo.com (web57210.mail.re3.yahoo.com [216.252.111.226]) by postgresql.org (Postfix) with SMTP id 562189FB1C5 for ; Sun, 6 Aug 2006 20:49:29 -0300 (ADT) Received: (qmail 10521 invoked by uid 60001); 6 Aug 2006 23:42:48 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.ca; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=bTq0zAEwrI0KUgJJXnJ65smCuAKrr55nYSBGDcltwo/W+rzxP9Hz2BGJpMVDKAj9T/8/vKLop1ueKLtNWpO1IciYdx1ysyuuo/UUTwpHFnQy1pi5XlJ1mw4gq8zwVopSf7sA2uMh9rhrKu4IOERt2xahRa+u10+Fhns6KE0y9VA= ; Message-ID: <20060806234247.10519.qmail@web57210.mail.re3.yahoo.com> Received: from [203.144.27.9] by web57210.mail.re3.yahoo.com via HTTP; Sun, 06 Aug 2006 16:42:47 PDT Date: Sun, 6 Aug 2006 16:42:47 -0700 (PDT) From: Geoff Parker Reply-To: Geoff Parker Subject: Disk usage in postgresql 8.1.4 To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1544511536-1154907767=:10015" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.497 tagged_above=0 required=5 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200608/59 X-Sequence-Number: 22603 --0-1544511536-1154907767=:10015 Content-Type: text/plain; charset=us-ascii 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. --0-1544511536-1154907767=:10015 Content-Type: text/html; charset=us-ascii
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.


--0-1544511536-1154907767=:10015--