ITYM DROP TABLE
От | David E. Wheeler |
---|---|
Тема | ITYM DROP TABLE |
Дата | |
Msg-id | 79A3A7F7-4448-4927-A1ED-104EF2B360D8@kineticode.com обсуждение исходный текст |
Ответы |
Re: ITYM DROP TABLE
Re: ITYM DROP TABLE Re: ITYM DROP TABLE |
Список | pgsql-hackers |
I was reading the partitioning docs when I spotted this. I think it means to highlight the advantages of DROP TABLE overDELETE 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 **** <para> Bulk loads and deletes can be accomplished by adding or removing partitions, ifthat requirement is planned into the partitioning design. ! <command>ALTER TABLE</> is far faster than a bulk operation. It also entirely avoids the <command>VACUUM</command> overhead caused by a bulk <command>DELETE</>. </para> --- 2332,2338 ---- <para> Bulk loads and deletes can be accomplished by adding or removing partitions, ifthat requirement is planned into the partitioning design. ! <command>DROP TABLE</> is far faster than a bulk operation. It also entirely avoids the <command>VACUUM</command> overhead caused by a bulk <command>DELETE</>. </para>
В списке pgsql-hackers по дате отправления: