Re: BYTEA

On Mon, Jan 18, 2016 at 11:25:43AM +1100, Cat wrote:

> On Sun, Jan 17, 2016 at 07:33:38PM +0000, Eugene Yin wrote:
> > Pg 9.4+
> > Storing binary data using bytea or text data types
> > - Pluses
> > - Storing and Accessing entry utilizes the same interface when accessing any other data type or record.
> > - No need to track OID of a "large object" you create
> >
> > - Minus
> >
> > - bytea and text data type both use TOAST (details here)
> > - limited to 1G per entry
> > - 4 Billion (> 2KB) entries per table max.
> >
> > - Need to escape/encode binary data before sending to DB then do the reverse after retrieving the data
> > - Memory requirements on the server can be steep even on a small record set. 
> > https://wiki.postgresql.org/wiki/BinaryFilesInDB
>
> Would http://multicorn.org/foreign-data-wrappers/#idfilesystem-foreign-data-wrapper be of greater use?

It would certainly be of use to add that option to the aforementioned wiki page.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346