| 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: | Whole Thread | Raw Message | 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 |