On Tue, 5 Jul 2011 10:43:38 +0200, Magnus Hagander wrote:
On Tue, Jul 5, 2011 at 10:38, Condor <condor@xxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
