| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Rod K" <rod(at)23net(dot)net> |
| Cc: | "Reshat Sabiq" <sabiq(at)purdue(dot)edu>, "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Images in Database |
| Date: | 2004-03-28 01:16:23 |
| Message-ID: | 10276.1080436583@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"Rod K" <rod(at)23net(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M. Bastin | 2004-03-28 02:20:56 | Re: Images in Database |
| Previous Message | Rod K | 2004-03-28 01:04:51 | Re: Images in Database |