On 2011-05-18, Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
> 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
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
*TOAST is a mechanism where oversize database records have the widest
values split off and stored separately, this process is transparent to
*I think LZ77, may be some other number
⚂⚃ 100% natural
In response to
pgsql-general by date
|Next:||From: Jasen Betts||Date: 2011-05-27 03:57:06|
|Subject: Re: Access to postgres conversion|
|Previous:||From: David Johnston||Date: 2011-05-27 00:58:57|
|Subject: Re: unnest with generate_subscripts and same array|