Home > mailing lists

Truncating table in PSQL reclaims hard disk? - Mailing list pgsql-novice

From	Freeda Suing
Subject	Truncating table in PSQL reclaims hard disk?
Date	August 24, 2015 14:08:03
Msg-id	CANcVi4PhezuNw4MDQR-6K36upLcUVYrb-Ri1fnS5P4ZpSUP1jw@mail.gmail.com Whole thread Raw
Responses	Re: Truncating table in PSQL reclaims hard disk? (s d <daku.sandor@gmail.com>)
List	pgsql-novice

Hi,

Does truncating a table automatically re-claim the hard disk or do I need to initiate vacuum after the truncate.

Thanks

From: CaT
Date: 23 August 2015, 14:50:37
Subject: Re: Importing dump file from MS SQL to PSQL 9.3

From: s d
Date: 24 August 2015, 14:38:50
Subject: Re: Truncating table in PSQL reclaims hard disk?