Hans Kristian Rosbach wrote: >> No you don't. A TOAST table is created by default. > > Yeah, I figured that after a while > >> It will compress most tuples without any intervention at all. > > Nice. Any idea what defines a "large enough" string?
Big enough so that the tuple is greater than 1/3 of the blocksize defined for the database cluster. (usually 8K). (I think it's 1/3, check the postgresql archives). (the rest of your questions are beyond me, so I'll leave them alone). -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
