Re: TOAST docs

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(at)Yahoo(dot)com #