agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Cat <cat@zip.com.au>
To: Eugene Yin <eugeneymail@ymail.com>
Cc: Postgres List <pgsql-sql@postgresql.org>
Subject: Re: BYTEA
Date: Mon, 18 Jan 2016 11:25:43 +1100
Message-ID: <20160118002543.GC11533@zip.com.au> (raw)
In-Reply-To: <194527298.6807703.1453059218766.JavaMail.yahoo@mail.yahoo.com>
References: <194527298.6807703.1453059218766.JavaMail.yahoo.ref@mail.yahoo.com>
<194527298.6807703.1453059218766.JavaMail.yahoo@mail.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (17+ messages) latest in thread
Message-ID: <20160118002543.GC11533@zip.com.au>
Permalink: ../20160118002543.GC11533@zip.com.au/
Also on: postgresql.org/message-id/20160118002543.GC11533@zip.com.au
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cat@zip.com.au, eugeneymail@ymail.com
Subject: Re: BYTEA
In-Reply-To: <20160118002543.GC11533@zip.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox