Re: BYTEA

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? Not sure if it's r/w or r/o.

--  "A search of his car uncovered pornography, a homemade sex aid, women's  stockings and a Jack Russell terrier."   -
http://www.dailytelegraph.com.au/news/wacky/indeed/story-e6frev20-1111118083480