Re: bytea characteristics

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "jws" <jsacksteder(at)gmail(dot)com>
Subject: Re: bytea characteristics
Date: 2007-02-10 08:59:59
Message-ID: 200702101000.01971.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Downs 2007-02-10 13:16:07 Trouble w/plperl sproc on red hat 9
Previous Message jws 2007-02-10 04:11:52 bytea characteristics