Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with TOAST tables when removing TOASTable column - Mailing list pgsql-bugs

From Wojciech Strzałka
Subject Re: Problem with TOAST tables when removing TOASTable column
Date
Msg-id 323199382.20080514172105@gmail.com
Whole thread Raw
In response to Re: Problem with TOAST tables when removing TOASTable column  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Problem with TOAST tables when removing TOASTable column  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
> 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with TOAST tables when removing TOASTable column
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows