From: | Perez <i(at)donotexist(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | trigger TOASTing quicker? |
Date: | 2006-05-12 03:15:16 |
Message-ID: | i-E761E0.23151111052006@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Caduto | 2006-05-12 03:32:30 | Re: GUI Interface |
Previous Message | Michael Schmidt | 2006-05-12 02:40:08 | Re: GUI Interface |