Database size

Поиск
Список
Период
Сортировка
Искать

Database size

От:
"Andrew Janian" <ajanian@scottrade.com>
Дата:
I have recently inherited a Postgres 7.2 DB.  I noticed that the size of the database on the disk is about 100 times the size of the nightly dumps that get done.  I looked into it and realized that after millions of rows are deleted each month there was no vacuum full performed on the DB.  I also noticed that the disk space was not recovered to the OS.  I assumed that was because there was no vacuum full being performed.  I am currently performing a vacuum full and noticing that no space is being recovered.  Is it normal for a DB to be that much bigger than it's dumps?

Thanks,

Andrew Janian

FAQ