Re: Images in Database

"Rod K" <rod@23net.net> writes:
> I also don't understand what information you have that leads you to make the
> claim that space is wasted.  I guess it is due to your assumption that a
> BLOB is used.  A bytea type takes 4 extra bytes than the actual size of the
> data.

Even when using BLOBs, there's not very significant overhead ---
certainly much less than the overhead of putting a small image into a
file, which is probably going to occupy at least 1K on disk.  I would
guess that the separate-files approach would be the most bulky of the
three choices.

            regards, tom lane