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
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" |