Re: Difference in DB size with dump andpg_database_size

On Tue, 5 Jul 2011 10:43:38 +0200, Magnus Hagander wrote:
> On Tue, Jul 5, 2011 at 10:38, Condor <condor@stz-bg.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