| From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ITYM DROP TABLE |
| Date: | 2011-06-14 16:33:27 |
| Message-ID: | 8C07B33E-E58F-4786-BC45-4699FA3599BF@kineticode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
Best,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Creager | 2011-06-14 16:34:36 | Re: Why polecat and colugos are failing to build back branches |
| Previous Message | Merlin Moncure | 2011-06-14 16:15:54 | Re: psql describe.c cleanup |