On 2009-11-26, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
> Hi list,
> I'm asking myself what solution for storing pictures is the best:
> * using a BYTEA column type, and having no intrinsic compression gain
> because a picture it almost every time already compressed,
> * using a TEXT column type, and store a Base64(picture) in it; it should
> take benefits of intrinsic compression (?).
use bytea and convert to/from base64 if you can't use the binary
interface and find the text interface inconvenient.
this will make the data over 1/3 bigger.
In response to
pgsql-novice by date
|Next:||From: Nathaniel Trellice||Date: 2009-11-27 11:04:21|
|Subject: How best to index foreign key for inner join|
|Previous:||From: Tom Lane||Date: 2009-11-27 06:49:39|
|Subject: Re: index speed-up and automatic tables/procedures creation |