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