[GENERAL] big database resulting in small dump

2012-07-20 Thread Ilya Ivanov
I have a 8.4 database (installed on ubuntu 10.04 x86_64). It holds Zabbix database. The database on disk takes 10Gb. SQL dump takes only 2Gb. I've gone through http://archives.postgresql.org/pgsql-general/2008-08/msg00316.php and got some hints. Naturally, the biggest table is history (the second b

Re: [GENERAL] big database resulting in small dump

2012-07-20 Thread Ilya Ivanov
well, it'd be good to have a link to the resource that says about 5x ratio, but in general I'm satisfied with that explanation. Thank you.