why the DB file size does not reduce when 'delete' the data in DB?

Поиск
Список
Период
Сортировка
Искать
От
Jaruwan Laongmal
Тема
why the DB file size does not reduce when 'delete' the data in DB?
Дата
Msg-id
000f01c0a315$ff81a0e0$6d9a96cb@ntl
Список
Дерево обсуждения
Re: [SQL] Re: why the DB file size does not reduce when 'delete'the data in DB? Thomas Lockhart <lockhart@alumni.caltech.edu>
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 по дате отправления
От: Ned Lilly
Дата:
От: Martin A. Marques
Дата:
FAQ