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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.