Re: [GENERAL] trigger TOASTing quicker?

2006-05-15 Thread Perez
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

[GENERAL] trigger TOASTing quicker?

2006-05-12 Thread Perez
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

Re: [GENERAL] trigger TOASTing quicker?

2006-05-12 Thread Martijn van Oosterhout
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

Re: [GENERAL] trigger TOASTing quicker?

2006-05-12 Thread Tom Lane
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