Skip site navigation (1) Skip section navigation (2)

Re: Images in Database

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: M. BastinDate: 2004-03-28 02:20:56
Subject: Re: Images in Database
Previous:From: Rod KDate: 2004-03-28 01:04:51
Subject: Re: Images in Database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group