Re: ITYM DROP TABLE

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: ITYM DROP TABLE
Дата
Msg-id 1308069991-sup-9676@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: ITYM DROP TABLE  ("David E. Wheeler" <david@kineticode.com>)
Ответы Re: ITYM DROP TABLE
Список 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 по дате отправления:

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: ITYM DROP TABLE
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: procpid?