On Wed, May 3, 2017 at 1:19 AM, Sumeet Shukla <sumeet(dot)k(dot)shukla(at)gmail(dot)com>
wrote:
> 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.
>
That ratio aligns with what I see in my <1TB databases. If you calculate
the size of just the data and exclude any indexes or relation bloat, that
total is what is compressed in your custom-format pg_dump backup.