"Michael Goldner" <MGoldner(at)agmednet(dot)com> 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