In article <24281.1147444664@xxxxxxxxxxxxx>, tgl@xxxxxxxxxxxxx (Tom Lane) wrote: > Martijn van Oosterhout <kleptog@xxxxxxxxx> writes: > > I beleive you can set it to EXTERNAL, which it will always toast. > > I don't think that will help; if the overall row size is below the > threshold, the code is not going to pick it apart to see if anything > is saying "toast me anyway!". And it shouldn't do so IMHO; the overall > cost in cycles would be catastrophic, because most tables aren't going > to have such columns. > > There was discussion just yesterday of making the TOAST thresholds > more configurable, but I didn't see anyone stepping up with a > concrete proposal (much less volunteering to create a patch). > > regards, tom lane Well, I suppose I could blank pad the column :-) That would compress really well, too. Or is that exceptionally evil? tia, arturo
