Re: How does TOAST compare to other databases' mechanisms? - Mailing list pgsql-general

> 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