ITYM DROP TABLE

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема ITYM DROP TABLE
Дата
Msg-id 79A3A7F7-4448-4927-A1ED-104EF2B360D8@kineticode.com
обсуждение исходный текст
Ответы Re: ITYM DROP TABLE  (Robert Haas <robertmhaas@gmail.com>)
Re: ITYM DROP TABLE  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: ITYM DROP TABLE  (Simon Riggs <simon@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Dan Ports
Дата:
Сообщение: Re: SSI patch renumbered existing 2PC resource managers??
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: wrong message on REASSIGN OWNED