From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Perez <i(at)donotexist(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: trigger TOASTing quicker? |
Date: | 2006-05-12 13:47:08 |
Message-ID: | 20060512134708.GE12955@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Schiltknecht | 2006-05-12 13:51:18 | rules: evaluate inputs in advance |
Previous Message | Martijn van Oosterhout | 2006-05-12 13:44:31 | Re: Triggers in C - Segmentation Fault |