Search Postgresql Archives

why is pg_dump so much smaller than my database?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux