"Michael Goldner" <[EMAIL PROTECTED]> writes:
> I have a database with a single table that includes an oid reference to a
> large object. After loading 100GB of large objects using lo_import(), I
> find that my total database size has grown by about 270GB. What is the
> reason for the difference in space usage?
Try VACUUM VERBOSE on your table and also on pg_largeobject to get a
sense of where the space went. I'm wondering whether you allowed for
indexes and for other data in your table.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings