Postgres Pro
Downloads
Home   >   mailing lists

pg_dump issues - Mailing list pgsql-general

From DM
Subject pg_dump issues
Date
Msg-id eae6a62a1002021507r7db3cc54v32bff70b732b5e2a@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump issues  (DM <dm.aeqa@gmail.com>)
Re: pg_dump issues  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: pg_dump issues  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
List pgsql-general
Tree view
Hi All,

I have a database with only one schema with 5 tables 

nspname |       relname           |  size
     ---------+---------------------+---------
     sch     | job1                      | 211 MB
     sch     | job2                      | 5611 MB
     sch     | job3                      | 6584 kB
     sch     | job4                      | 89 MB
     sch     | job5                      | 39 MB

Total sum of sizes of the table is less than 6 GB.

When I do a pg_dump of this database it is 20GB (I also did a pg_dump of only schema data and the size was still the same). I am using postgres 8.4.1 version.

Could any one explain why the pg_dump size of the file is 3 times the size of the tables?

Thanks
Deepak

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Questions on PostGreSQL Authentication mechanism...
Next
From: DM
Date:
Subject: Re: pg_dump issues