Re: Re: Please help me to take a look of the erros in my functions. Thanks.

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: Please help me to take a look of the erros in my functions. Thanks.
Date: 2012-04-03 18:00:33
Message-ID: 4F7B3AC1.30103@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message leaf_yxj 2012-04-03 18:13:18 Re: Please help me to take a look of the erros in my functions. Thanks.
Previous Message leaf_yxj 2012-04-03 17:54:35 Re: Please help me to take a look of the erros in my functions. Thanks.