In article <[EMAIL PROTECTED]>,
 [EMAIL PROTECTED] (Tom Lane) wrote:

> Martijn van Oosterhout <kleptog@svana.org> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to