Re: Re: Please help me to take a look of the erros in my functions. Thanks. - Mailing list pgsql-general

From John R Pierce
Subject Re: Re: Please help me to take a look of the erros in my functions. Thanks.
Date
Msg-id 4F7B63D6.3040503@hogranch.com
Whole thread Raw
In response to Re: Please help me to take a look of the erros in my functions. Thanks.  (leaf_yxj <leaf_yxj@163.com>)
List pgsql-general
On 04/03/12 11:13 AM, leaf_yxj wrote:
> Hi John, Thanks for your reply. Just to confirm :  so truncate table
> means the space will be reclaim for reuse ???

yes, all the tablespace is immediately returned to the file system when
the transaction with the TRUNCATE statement commits.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: views, queries, and locks
Next
From: Jon Nelson
Date:
Subject: Re: views, queries, and locks