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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026