Skip site navigation (1) Skip section navigation (2)

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

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 500KB PDF saving into large object , what is the table size?
Date: 2011-05-27 03:53:16
Message-ID: irn77c$dso$1@reversiblemaps.ath.cx (view raw or flat)
Thread:
Lists: pgsql-general
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


In response to

pgsql-general by date

Next:From: Jasen BettsDate: 2011-05-27 03:57:06
Subject: Re: Access to postgres conversion
Previous:From: David JohnstonDate: 2011-05-27 00:58:57
Subject: Re: unnest with generate_subscripts and same array

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group