Postgres Pro
Downloads
Home   >   mailing lists

why is pg_dump so much smaller than my database? - Mailing list pgsql-general

From Carson Gross
Subject why is pg_dump so much smaller than my database?
Date
Msg-id CAO92UoHBOaWauifeH0dznG=YvtJa85FezTHGFLRtVb7cGGmzPA@mail.gmail.com
Whole thread Raw
Responses Re: why is pg_dump so much smaller than my database?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
I've got a pretty big database (~30 gigs) and when I do a pg_dump, it ends up only being 2 gigs.

The database consists mainly of one very large table (w/ a few varchar columns) which, according to pg_relation_size() is 10 gigs and pg_total_relation_size() is 26 gigs (we need to drop some indexes there.)  

I'm just trying to get my head around the pg_dump being an order of magnitude smaller than the darned database itself.  I would thing that the db would offer more efficient encoding for a lot of stuff vs. an ascii file.

Thanks,
Carson

pgsql-general by date:

Previous
From: Arvind Singh
Date:
Subject: PG Log
Next
From: John R Pierce
Date:
Subject: Re: why is pg_dump so much smaller than my database?