On 2011-05-18, Emi Lu <emilu@xxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
