Re: Disk usage in postgresql 8.1.4

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Geoff Parker <geoffparkernews(at)yahoo(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Disk usage in postgresql 8.1.4
Date: 2006-08-07 01:29:31
Message-ID: 20060807012931.GA31473@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Aug 06, 2006 at 04:42:47PM -0700, Geoff Parker wrote:
> 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?

Large objects are stored in pg_largeobject as chunks of bytea data,
which can be compressed.

--
Michael Fuhr

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Browne 2006-08-07 01:47:39 Re: running PostGres without installing it
Previous Message Amadeus Zilfinski 2006-08-07 01:01:22 Re: running PostGres without installing it