ITYM DROP TABLE - Mailing list pgsql-hackers

From David E. Wheeler
Subject ITYM DROP TABLE
Date
Msg-id 79A3A7F7-4448-4927-A1ED-104EF2B360D8@kineticode.com
Whole thread Raw
Responses Re: ITYM DROP TABLE
Re: ITYM DROP TABLE
Re: ITYM DROP TABLE
List 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 by date:

Previous
From: Dan Ports
Date:
Subject: Re: SSI patch renumbered existing 2PC resource managers??
Next
From: Alvaro Herrera
Date:
Subject: Re: wrong message on REASSIGN OWNED