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.
signature.asc
Description: Digital signature
