Re: ITYM DROP TABLE - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: ITYM DROP TABLE
Date
Msg-id 1308069991-sup-9676@alvh.no-ip.org
Whole thread Raw
In response to Re: ITYM DROP TABLE  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: ITYM DROP TABLE
List 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@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: ITYM DROP TABLE
Next
From: Jim Nasby
Date:
Subject: Re: procpid?