Postgres Pro
Downloads
Home   >   mailing lists

why the DB file size does not reduce when 'delete' the data in DB? - Mailing list pgsql-hackers

From Jaruwan Laongmal
Subject why the DB file size does not reduce when 'delete' the data in DB?
Date
Msg-id 000f01c0a315$ff81a0e0$6d9a96cb@ntl
Whole thread Raw
Responses Re: why the DB file size does not reduce when 'delete' the data in DB?  ("Martin A. Marques" <martin@math.unl.edu.ar>)
Re: why the DB file size does not reduce when 'delete' the data in DB?  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
Tree view 
I had deleted a very large number of records out of my SQL table in order to
decrease the harddisk space.  But after I use command 'ls -l
/usr/local/pgsql/data/base/', it is found that the size of concerning files
do not reduce due to the effect of 'delete' SQL command.  What should I do
if I would like to decrease the harddisk space?

I am looking forward to your response.  Thank you very much for any help.
-
Jaruwan

pgsql-hackers by date:

Previous
From: Ned Lilly
Date:
Subject: 7.2 tools (was: WAL's single point of failure: latest CHECKPOINT record)
Next
From: "Martin A. Marques"
Date:
Subject: Re: why the DB file size does not reduce when 'delete' the data in DB?