Re: Database size with large objects

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"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