Hi all, I'm in the planning stages of replacing a MySQL DB using ISAM tables with PostgreSQL 8.1.x on Suse 10.0. I think that sentence right there will tell you why! Anyway, one of the columns in one of the tables is a big chunk of XML (500 to 500KB). I'm not normally a fan of that kind of thing, much preferring storing such things in the file system. But I see that TOASTing that column will address most of my concerns. On to my questions: 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.... 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; tia, arturo
