View Single Post

   
  #2 (permalink)  
Old 05-16-2008, 01:42 PM
=?iso-8859-2?Q?Wojciech_Strza=B3ka?=
 
Posts: n/a
Default Re: Problem with TOAST tables when removing TOASTable column


> To make that happen would require (at least) a full table scan. I think
> most people are more interested in DROP COLUMN being a cheap operation
> than in having the space be reclaimed quickly.


> For a comparison point: large field values that don't happen to get
> toasted don't vanish immediately, either.


I agree DROP COLUMN should be cheap and I don't really expect it to happend immediately,
but shouldn't VACUUM FULL clean it up?


Wojtek Strzalka






--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply With Quote