Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] pg_dump backup size very less - Mailing list pgsql-admin

From bricklen
Subject Re: [ADMIN] pg_dump backup size very less
Date
Msg-id CAGrpgQ9Ot4qc6qEf7LR740kSYaQefaNx+3qdpioBve_iudw2HQ@mail.gmail.com
Whole thread Raw
In response to [ADMIN] pg_dump backup size very less  (Sumeet Shukla <sumeet.k.shukla@gmail.com>)
List pgsql-admin
Tree view
On Wed, May 3, 2017 at 1:19 AM, Sumeet Shukla <sumeet.k.shukla@gmail.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.

pgsql-admin by date:

Previous
From: vinny
Date:
Subject: Re: [ADMIN] pg_dump backup size very less
Next
From: "Gone, Sajan"
Date:
Subject: [ADMIN] Setting wild card IP's on postgres