Обсуждение: pg_dump file size

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

pg_dump file size

От
Mike angelo
Дата:
I'm a newb  running Postgres 8.3 on a SuSE 7.2 system. I have a database whose size reports as 644 MB using
 
select pg_size_pretty(pg_database_size('adempiere'));
 
When using the following command to back up the database,
 

su postgres -c "pg_dump adempiere | split -b 3000m - /tmp/adempiere_`date +%F`.dmp"

 

the result is a 49.5 MB file. Curious as to how the backup file can be less than 1/10th the size of the database?

 

Thanks,

 

-Mike


Re: pg_dump file size

От
Tom Lane
Дата:
Mike angelo <angelocmp@yahoo.com> writes:
> Curious as to how the backup file can be less than 1/10th the size of the database?

The dump doesn't contain indexes (only commands to create them).
You might also be suffering a bit of table and/or index bloat
in the database.

            regards, tom lane