Re: Toasted table not deleted when no out of line columns left - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Toasted table not deleted when no out of line columns left
Date
Msg-id 1222075723.4445.126.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Toasted table not deleted when no out of line columns left  ("Hans-Jürgen Schönig" <hs@cybertec.at>)
Responses Re: Toasted table not deleted when no out of line columns left  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, 2008-09-22 at 10:59 +0200, Hans-Jürgen Schönig wrote:
> On Sep 22, 2008, at 9:46 AM, Simon Riggs wrote:

> > I thought Hans meant cleanup, not drop?

> we definitely have to do something about this problem. 

I think the issue is identifying the problem. Reading the title of the
post, I think Tom says "no" to *deleting* the toast table. He also says
"no" to cleaning the table as part of DROP COLUMN. That still leaves you
an opening for an out-of-line command/function to perform a clean,
without deleting the table completely.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: "Hans-Jürgen Schönig"
Date:
Subject: Re: Toasted table not deleted when no out of line columns left
Next
From: Simon Riggs
Date:
Subject: Re: Initial prefetch performance testing