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.
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 |