Re: Database size with large objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael Goldner" <MGoldner(at)agmednet(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database size with large objects
Date: 2007-11-05 00:26:53
Message-ID: 29838.1194222413@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Goldner 2007-11-05 03:03:43 Re: Database size with large objects
Previous Message Michael Goldner 2007-11-04 22:49:13 Database size with large objects