Re: Applying TOAST to CURRENT

> I agree with Bruce --- the toast table should be created automatically,
> at least if the table contains any potentially-toastable columns. We
> want this to be as transparent as possible. I'd rather have auto create
> on-the-fly when first needed, but if that seems too risky then let's
> just make the table when its owning table is created.
>
> If you want to control it with an ALTER TABLE function, let's add ALTER
> TABLE DROP TOAST so that admins who don't like the excess space usage
> can get rid of it. (Of course that should only succeed after verifying
> the toast table is empty...)

But when you vacuum a table, doesn't it get zero size? Sure works here:

#$ cd /u/pg/data/base/test
#$ ls -l kkk*
-rw------- 1 postgres postgres 0 May 30 12:20 kkk
#$

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026