Large Object table data file does not have expected size

From: u15074 <u15074(at)hs-harz(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Large Object table data file does not have expected size
Date: 2003-06-27 08:08:34
Message-ID: 1056701314.3efbfb822511c@webmail.hs-harz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am a little bit confused by the following effect.
For test reasons I insert about 100000 large objects into the database. Each has
a size of 10240 Bytes (10K). So the expected size of the large object datafile
should be at least 1024000000 Bytes (about 976MB) just to hold the large objects.
But the according data file is much smaller than that. If I query the large
objetcs from psql all data seems to be there (i just randomly picked out some
large objects). I first thought there was a bug in my test program (not all
large objetcs are inserted), but I couldn't find one. Also this was unlikely,
since I always insert the same binary data (for the large objetc) in a simple loop.

Has anyone an idea why the datafiles are much smaller than I expect them to be?

Thanks, Andreas.

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message u15074 2003-06-27 08:12:02 Is it possible to change the wal file size?
Previous Message Tom Lane 2003-06-27 07:21:49 Re: Making pgsql error messages more developers' friendly.