Re: bytea characteristics - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: bytea characteristics
Date
Msg-id 200702101000.01971.peter_e@gmx.net
Whole thread Raw
In response to bytea characteristics  ("jws" <jsacksteder@gmail.com>)
List pgsql-general
jws wrote:
> Do the images take up a certain percentage more space due to the on-
> disk format when stored this way?

Bytes are pretty much stored just as bytes, with four bytes of overhead
for the length field.  Larger values (> 2kB) are stored out of line, so
there really shouldn't be much concern about storing the image data in
the database.  It's probably more of a question what makes your
processing easier.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: "jws"
Date:
Subject: bytea characteristics
Next
From: Kenneth Downs
Date:
Subject: Trouble w/plperl sproc on red hat 9