Re: trigger TOASTing quicker?

On Thu, May 11, 2006 at 11:15:16PM -0400, Perez wrote:
> TOASTing is automatic?  I don't have to code anything for it?  Plain
> vanilla SQL99 will work with it?  I have terrible memories of Oracle's
> LONG RAW columns....

TOAST is automatic, yes. It's also transparent (ie there's no
functionality difference).

> Assuming the above is true, is there anyway to get a column's data to
> TOAST at a threshold smaller than the default of 2000B?  For example, I
> really would like any amount of data stored in the XML column to be
> TOASTed.  So I would like to be able to say something like
> ALTER TABLE foo ALTER COLUMN xml SET STORAGE EXTENDED;
> ALTER TABLE foo ALTER COLUMN xml SET EXTENDED_THRESHOLD 500;

I beleive you can set it to EXTERNAL, which it will always toast.

Have a ncie day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.