Re: Toasted table not deleted when no out of line columns left

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>, Zoltan Boszormenyi <zb(at)cybertec(dot)at>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Toasted table not deleted when no out of line columns left
Date: 2008-09-22 11:53:23
Message-ID: 11327.1222084403@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> 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,

... see CLUSTER ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-09-22 12:24:48 Re: pg_dump feature
Previous Message Tom Lane 2008-09-22 11:51:43 Re: [patch] fix dblink security hole