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 по дате отправления