> 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