ITYM DROP TABLE

Поиск
Список
Период
Сортировка
Искать
От
David E. Wheeler
Тема
ITYM DROP TABLE
Дата
Msg-id
79A3A7F7-4448-4927-A1ED-104EF2B360D8@kineticode.com
Список
Дерево обсуждения
ITYM DROP TABLE "David E. Wheeler" <david@kineticode.com>
Re: ITYM DROP TABLE Alvaro Herrera <alvherre@commandprompt.com>
Re: ITYM DROP TABLE Tom Lane <tgl@sss.pgh.pa.us>
Re: ITYM DROP TABLE "David E. Wheeler" <david@kineticode.com>
Re: ITYM DROP TABLE Alvaro Herrera <alvherre@commandprompt.com>
Re: ITYM DROP TABLE Tom Lane <tgl@sss.pgh.pa.us>
Re: ITYM DROP TABLE Alvaro Herrera <alvherre@commandprompt.com>
Re: ITYM DROP TABLE Simon Riggs <simon@2ndQuadrant.com>
Re: ITYM DROP TABLE Robert Haas <robertmhaas@gmail.com>
I was reading the partitioning docs when I spotted this. I think it means to highlight the advantages of DROP TABLE over DELETE rather than ALTER TABLE.

Best,

David

diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index 4c9fc5d..0cdb800 100644
*** a/doc/src/sgml/ddl.sgml
--- b/doc/src/sgml/ddl.sgml
*************** VALUES ('New York', NULL, NULL, 'NY');
*** 2332,2338 ****             Bulk loads and deletes can be accomplished by adding or removing       partitions, if that requirement is planned into the partitioning design.
!       ALTER TABLE</> is far faster than a bulk operation.       It also entirely avoids the VACUUM       overhead caused by a bulk DELETE</>.      
--- 2332,2338 ----             Bulk loads and deletes can be accomplished by adding or removing       partitions, if that requirement is planned into the partitioning design.
!       DROP TABLE</> is far faster than a bulk operation.       It also entirely avoids the VACUUM       overhead caused by a bulk DELETE</>.      


В списке pgsql-hackers по дате отправления
От: Dan Ports
Дата:
От: Alvaro Herrera
Дата:
FAQ