Re: TOAST docs
От | Jan Wieck |
---|---|
Тема | Re: TOAST docs |
Дата | |
Msg-id | 3D8225C5.FEFF2DB0@Yahoo.com обсуждение исходный текст |
Ответ на | Re: TOAST docs (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-hackers |
Joe Conway wrote: > > Hannu Krosing wrote: > > IIRC there were some ways to tweak when TOAST gets used, when it goes > > out to toastfile and when it uses compressed/non-compressed storage. > > > > I hope this is documented someplace, no ? > > There is a mention of it in the ALTER TABLE doc: > > ALTER TABLE [ ONLY ] table [ * ] > ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } > > SET STORAGE > > This form ... We have that already? Seems my memory doesn't serve as good as it used to ... I'm getting old, folks. Thanks to whoever did it. Now the other magic thingy is, that on CREATE TABLE the column storage is taken from the pg_type entry. Someone could manipulate that and default all text columns to external for example. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
В списке pgsql-hackers по дате отправления: