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

From Tom Lane
Subject Re: Problem with TOAST tables when removing TOASTable column
Date
Msg-id 19781.1210777881@sss.pgh.pa.us
Whole thread Raw
In response to Problem with TOAST tables when removing TOASTable column  (Wojciech Strzałka <wstrzalka@gmail.com>)
Responses Re: Problem with TOAST tables when removing TOASTable column
List pgsql-bugs
Wojciech Strzałka <wstrzalka@gmail.com> writes:
> In my opinion the fact that dropping column doesn't release it's toastable resources is a bug.

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.
        regards, tom lane


pgsql-bugs by date:

Previous
From: "nicoanto"
Date:
Subject: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows
Next
From: Wojciech Strzałka
Date:
Subject: Re: Problem with TOAST tables when removing TOASTable column