500KB PDF saving into large object , what is the table size?

Emi Lu wrote:

A question about large object column type in postgresql8.3.

A pdf file=500KB.

If saving into large object column, will the table size be around

500KB?

If larger than 500KB, what could be the proximate size?

It should never be noticably bigger than 500K.

Yours,
Laurenz Albe

On 2011-05-18, Emi Lu <emilu@encs.concordia.ca> wrote:

Hello,

A question about large object column type in postgresql8.3.

A pdf file=500KB.

8.3 has bytea and largeobject.

Largeoibject isn't stored to the table, only a smaller OID is (looks
like an integer). largeobject has a stream interface, but not a value
interface.

bytea is is stored to the table (values os the size being discussed are
actually stored to the TOAST* table).

If saving into large object column, will the table size be around 500KB?
If larger than 500KB, what could be the proximate size?

LZ* compression will be tried, this may result in a slight size
reduction, in the worst case it mon't take up much much more than the
original size.

*TOAST is a mechanism where oversize database records have the widest
values split off and stored separately, this process is transparent to
the user.

*I think LZ77, may be some other number

--
⚂⚃ 100% natural