why the DB file size does not reduce when 'delete' the data in DB?
From:
"Jaruwan Laongmal" <jaruwan(at)gits(dot)net(dot)th>
To:
<pgsql-hackers(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject:
why the DB file size does not reduce when 'delete' the data in DB?
Date:
2001-03-02 12:40:42
Message-ID:
000f01c0a315$ff81a0e0$6d9a96cb@ntl (view raw or flat )
Thread:
2001-03-02 12:40:42 from "Jaruwan Laongmal" <jaruwan(at)gits(dot)net(dot)th>
2001-03-02 12:04:45 from The Hermit Hacker <scrappy(at)hub(dot)org>
2001-03-04 02:01:37 from "xuyifeng" <jamexu(at)telekbird(dot)com(dot)cn>
2001-03-04 03:05:29 from The Hermit Hacker <scrappy(at)hub(dot)org>
2001-03-04 07:15:18 from "xuyifeng" <jamexu(at)telekbird(dot)com(dot)cn>
2001-03-04 18:37:11 from "Mitch Vincent" <mitch(at)venux(dot)net>
2001-03-06 23:46:01 from Mathijs Brands <mathijs(at)ilse(dot)nl>
2001-03-07 03:10:45 from Xu Yifeng <jamexu(at)telekbird(dot)com(dot)cn>
2001-03-07 02:25:27 from Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
2001-03-16 01:28:46 from yves(at)mail2(dot)vlaanderen(dot)net
2001-03-07 03:14:42 from The Hermit Hacker <scrappy(at)hub(dot)org>
2001-03-07 03:33:07 from Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
2001-03-02 12:36:02 from "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
2001-03-02 13:30:38 from Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
2001-03-02 15:03:05 from Hannu Krosing <hannu(at)tm(dot)ee>
Lists:
pgsql-hackers pgsql-sql
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
Responses
pgsql-hackers by date
Next :From: Thomas LockhartDate: 2001-03-02 13:30:38Subject : Re: [HACKERS] why the DB file size does not reduce when 'delete' the
data in DB?Previous :From : Martin A. MarquesDate : 2001-03-02 12:36:02Subject : Re: why the DB file size does not reduce when 'delete' the data in
DB?
pgsql-sql by date
Next :From: Thomas LockhartDate: 2001-03-02 13:30:38Subject : Re: [HACKERS] why the DB file size does not reduce when 'delete' the
data in DB?Previous :From : Martin A. MarquesDate : 2001-03-02 12:36:02Subject : Re: why the DB file size does not reduce when 'delete' the data in
DB?
