Hi all,
I am using Pg 7.3 for a document management database. Up
to now, I have been storing documents in the database as
large objects in compressed form. For example, my script
will gzip a pdf document and insert into pgsql. That way
all the metadata relating to the document and the document
itself is in the same place.
However, 4.5 gb of data is taking up approximately 6 gb in
pgsql and I am thinking of moving the documents out and
storing on the filesystem itself. My question is, is there
any other formats (encoding perhaps) I can tell pgsql to
use such that the space usage is better. At present, the
space tradeoff is small but when the database grows, I
imagine as will the wasted space.
Best regards,
Shane
--
http://www.cm.nu/~shane/
PGP: 1024D/FFE3035D
A0ED DAC4 77EC D674 5487
5B5C 4F89 9A4E FFE3 035D