Re: How does TOAST compare to other databases' mechanisms?

> Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> > In the case of images, is there a way to tell TOAST not to bother even
> > trying to compress the data? (eg. JPEG files). If so, would I be right in
> > assuming that this would be better for fast retrieval (even for text
> > files)?
>
> TOAST will not store a compressed value unless the compressed value is
> smaller than the uncompressed by some reasonable amount (which looks to
> be 20% by default). I'd expect JPEG-like data always to fail the

Yea, I know, I have never heard of JPEG either, but Tom Lane is Mr.
Internet JPEG, so humor him. :-)

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026