[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] pg_dump backup size very less
From:       bricklen <bricklen () gmail ! com>
Date:       2017-05-03 13:28:54
Message-ID: CAGrpgQ9Ot4qc6qEf7LR740kSYaQefaNx+3qdpioBve_iudw2HQ () mail ! gmail ! com
[Download RAW message or body]

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.

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Wed, May 3, 2017 \
at 1:19 AM, Sumeet Shukla <span dir="ltr">&lt;<a \
href="mailto:sumeet.k.shukla@gmail.com" \
target="_blank">sumeet.k.shukla@gmail.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div>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.</div></div></blockquote><div><br></div><div>  That \
ratio aligns with what I see in my &lt;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.<br></div></div><br></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]