On E, 2004-11-29 at 02:22, David Garamond wrote: > Joe Conway wrote: > > Not if the column is storage type EXTERNAL. See a past discussion here: > > http://archives.postgresql.org/pgsql-general/2003-07/msg01447.php > > what is the reasoning behind this syntax? > > ALTER TABLE [ ONLY ] table [ * ] > ALTER [ COLUMN ] column SET STORAGE > { PLAIN | EXTERNAL | EXTENDED | MAIN } > > I find it nonintuitive and hard to remember. Perhaps something like this > is better (I know, it's probably too late): > > ALTER [ COLUMN ] column SET STORAGE { INLINE | EXTERNAL } > ALTER [ COLUMN ] column SET COMPRESSION { YES | NO }
It wold also be beneficial if the threshold size of moving the column to TOAST (either COMPRESS or EXTERNAL) could be set on a per-column basis This is a design decision on the same lavel as the others ------------ Hannu ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend