Re: Database size with large objects - Mailing list pgsql-admin

"Michael Goldner" <MGoldner@agmednet.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