From: | Condor <condor(at)stz-bg(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Difference in DB size with dump and pg_database_size |
Date: | 2011-07-05 09:03:23 |
Message-ID: | 09c7f0fab975bfacd85d615cdafaa863@stz-bg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 5 Jul 2011 10:43:38 +0200, Magnus Hagander wrote:
> On Tue, Jul 5, 2011 at 10:38, Condor <condor(at)stz-bg(dot)com> wrote:
>> Hello,
>> any one can explain me why I have difference between db size when I
>> dump db,
>> I see it's 5G and when I run SELECT
>> pg_size_pretty(pg_database_size('somedatabase')) As fulldbsize; on
>> my DB
>> postgresql return: 10 GB
>>
>> I run vacuum on db every night. Why is that huge difference in size
>> ?
>
> The dump does not include indexes - for each index it just contains
> the CREATE INDEX statement, not the actual data in the index.
>
> And perhaps you've also compressed your dumps? Though in that case,
> the difference would probably be bigger...
>
> --
> Magnus Hagander
> Me: http://www.hagander.net/
> Work: http://www.redpill-linpro.com/
Thank you for your fast replay. Yes, I gzip my DB but that file size is
when I uncompress the gziped file. Anyway, I got the answer. Thank you.
--
Regards,
Condor
From | Date | Subject | |
---|---|---|---|
Next Message | Tomáš Vondra | 2011-07-05 09:19:35 | Re: Difference in DB size with dump and pg_database_size |
Previous Message | Condor | 2011-07-05 09:00:45 | Dump large DB and restore it after all. |