Re: Disk usage in postgresql 8.1.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux