Doesn't PostgreSQL clean data in data file after delete records form table?

From: zh1029 <zh1029(at)sina(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Doesn't PostgreSQL clean data in data file after delete records form table?
Date: 2016-03-23 10:27:45
Message-ID: 1458728865813-5894764.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
we are using PostgreSQL 9.3.6 version and observe data file size is not
decreased after we deleted records from the table. It looks quite abnormal.
Is it as PostreSQL designed?

DBTestPostgres=# select count (*) from test_data ;
0

# ls -l
total 788932
.............
-rw------- 1 _nokfssystestpostgres root *801067008* Mar 23 17:51 32768
-rw------- 1 _nokfssystestpostgres root 221184 Mar 23 17:47 32768_fsm
-rw------- 1 _nokfssystestpostgres root 0 Mar 23 17:44 32768_vm
-rw------- 1 _nokfssystestpostgres root 0 Mar 23 17:43 32771
-rw------- 1 _nokfssystestpostgres root 8192 Mar 23 17:43 32773
-rw------- 1 _nokfssystestpostgres root 512 Mar 23 13:57
pg_filenode.map
-rw------- 1 _nokfssystestpostgres root 116404 Mar 23 17:19
pg_internal.init
-rw------- 1 _nokfssystestpostgres root 4 Mar 23 13:57 PG_VERSION

Thanks!

--
View this message in context: http://postgresql.nabble.com/Doesn-t-PostgreSQL-clean-data-in-data-file-after-delete-records-form-table-tp5894764.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2016-03-23 10:33:25 Re: Doesn't PostgreSQL clean data in data file after delete records form table?
Previous Message Chris Travers 2016-03-23 08:48:20 Re: Partitioning and ORM tools