Re: pg_dump issues

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: DM <dm(dot)aeqa(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump issues
Date: 2010-02-02 23:21:09
Message-ID: 4B68B365.9040106@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

DM a écrit :
> 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?

Because it doesn't only contains the fields values but also the full
set of commands to restore (remake) it identical (and it's text).
Also, if you use UTF-8, some chars take more than one byte per each.

--
Call on God, but row away from the rocks.
-- Indian proverb

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florent THOMAS 2010-02-02 23:28:13 Attribute a value to a record
Previous Message Scott Marlowe 2010-02-02 23:20:55 Re: pg_dump issues