From: vinny <vinny@xs4all.nl>
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: pgsql-admin-owner@postgresql.org
Subject: Re: pg_dump backup size very less
Date: Wed, 03 May 2017 11:35:12 +0200
Message-ID: <3910ced5eb365c3a0d3926bd7c739cc4@xs4all.nl> (raw)
In-Reply-To: <CABUL137gBFP0_EC4RMYbzsNVXXy27H5hpD7+m0qTiNbeBh_p1A@mail.gmail.com>
References: <CABUL137gBFP0_EC4RMYbzsNVXXy27H5hpD7+m0qTiNbeBh_p1A@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vinny@xs4all.nl, sumeet.k.shukla@gmail.com, pgsql-admin-owner@postgresql.org
Subject: Re: pg_dump backup size very less
In-Reply-To: <3910ced5eb365c3a0d3926bd7c739cc4@xs4all.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox