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