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
In response to
pgsql-general by date
|Next:||From: Michael Nolan||Date: 2012-04-03 22:21:45|
|Subject: Fwd: [GENERAL] 9.1.3: launching streaming replication|
|Previous:||From: Scott Marlowe||Date: 2012-04-03 20:05:07|
|Subject: Re: views, queries, and locks|