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

On 2011-05-18, Emi Lu <emilu(at)encs(dot)concordia(dot)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