Re: ITYM DROP TABLE

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: David E(dot) Wheeler <david(at)kineticode(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ITYM DROP TABLE
Date: 2011-06-14 16:46:54
Message-ID: 1308069991-sup-9676@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Excerpts from David E. Wheeler's message of mar jun 14 12:33:27 -0400 2011:
> On Jun 14, 2011, at 8:03 AM, Tom Lane wrote:
>
> >> - <command>ALTER TABLE</> is far faster than a bulk operation.
> >> + <command>ALTER TABLE</> (to split out a sub-table from the partitioned
> >> + table) and <command>DROP TABLE</> (to remove a partition altogether) are
> >> + both far faster than a bulk operation.
> >
> > I think you need to spell out "ALTER TABLE NO INHERIT" if you are going
> > to do that. This formulation seems to imply that *any* form of ALTER
> > TABLE is fast, which surely ain't the truth.
> >
> >> However, this introductory text is supposed to be very brief; maybe we
> >> should remove mention of specific commands here.
> >
> > No, I don't think it needs to be that brief. But if you think your
> > version is too long, remove the parenthetical remarks.
>
> +1 I think that would be perfect.

Done that way (9.0 and beyond).

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2011-06-14 16:58:40 Re: [Pgbuildfarm-members] Polecat "quit unexpectdly"
Previous Message Robert Creager 2011-06-14 16:45:32 Polecat "quit unexpectdly"