On 04/03/12 10:49 AM, leaf_yxj wrote:
--- I amn't sure what's differences between truncate and delete in postgresql. Could you do me a favour to tell me about this.
delete has to go through and flag each tuple for deletion so vacuum can eventually go through and reclaim them for reuse. truncate wipes the whole table out, including 0 length the files.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
