| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 14:16:28 |
| Message-ID: | 1222092988.4445.168.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 2008-09-22 at 07:53 -0400, Tom Lane wrote:
> 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 ...
It's possible we'd want to do this even with no indexes on a table and
we definitely might want to do it without taking lengthy locks.
It's good that DROP COLUMN is very quick, but its not good that it
doesn't remove the space and there's no way to make it do that without
requiring locks to be held for long periods.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2008-09-22 14:55:55 | Re: Toasted table not deleted when no out of line columns left |
| Previous Message | Heikki Linnakangas | 2008-09-22 14:13:47 | Re: WIP patch: Collation support |