"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

Reply via email to