trigger TOASTing quicker?

Поиск
Список
Период
Сортировка
Искать
От
Perez
Тема
trigger TOASTing quicker?
Дата
в 10:35:02
Msg-id
i-E761E0.23151111052006@news.hub.org
Список
Дерево обсуждения
trigger TOASTing quicker? Perez <i@donotexist.com>
Re: trigger TOASTing quicker? Martijn van Oosterhout <kleptog@svana.org>
Re: trigger TOASTing quicker? Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-general по дате отправления
От: Melanie Diedericks
Дата:
От: Chris Coleman
Дата:
FAQ