On 2017-05-03 10:19, Sumeet Shukla wrote:
> Hi,
>
> pg_dump in custom format is creating a dump of only 29 GB for a DB of
> size 700GB. Can you please help me understand what could be the reason
> behind it.
>
> Thanks & Regards,
> Sumeet Shukla
How did you measure that 700GB value? The total "database size" may
include space used by indexes
and other data objects that are not included in the dump because they
are simply re-created
when you do a restore.
The Wiki has articles on how to measure the size of your database,
splitting up data and indexes etc.
That may help you find out where that 700GB comes from and what that
29GB really is.
Regards,
VIncent