pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump backup size very less
4+ messages / 4 participants
[nested] [flat]
* pg_dump backup size very less
@ 2017-05-03 08:19 Sumeet Shukla <sumeet.k.shukla@gmail.com>
0 siblings, 3 replies; 4+ messages in thread
From: Sumeet Shukla @ 2017-05-03 08:19 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump backup size very less
@ 2017-05-03 08:56 Aniruddha Deshpande <daniruddha29@gmail.com>
parent: Sumeet Shukla <sumeet.k.shukla@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Aniruddha Deshpande @ 2017-05-03 08:56 UTC (permalink / raw)
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>; +Cc: pgsql-admin
Hi,
Checking bloat on that DB may help to understand why this was 29 GB.
Regards,
Anir
On Wed, May 3, 2017 at 1:49 PM, Sumeet Shukla <sumeet.k.shukla@gmail.com>
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump backup size very less
@ 2017-05-03 09:35 vinny <vinny@xs4all.nl>
parent: Sumeet Shukla <sumeet.k.shukla@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: vinny @ 2017-05-03 09:35 UTC (permalink / raw)
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>; +Cc: pgsql-admin; pgsql-admin-owner@postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_dump backup size very less
@ 2017-05-03 13:28 bricklen <bricklen@gmail.com>
parent: Sumeet Shukla <sumeet.k.shukla@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: bricklen @ 2017-05-03 13:28 UTC (permalink / raw)
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-05-03 13:28 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-05-03 08:19 pg_dump backup size very less Sumeet Shukla <sumeet.k.shukla@gmail.com>
2017-05-03 08:56 ` Aniruddha Deshpande <daniruddha29@gmail.com>
2017-05-03 09:35 ` vinny <vinny@xs4all.nl>
2017-05-03 13:28 ` bricklen <bricklen@gmail.com>
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