> Philip Warner <pjw@rhyme.com.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@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026