On Wed, May 3, 2017 at 1:19 AM, Sumeet Shukla <sumeet.k.shukla@xxxxxxxxx> 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.