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 biggest is
history_uint. Together they make about 95% of total size). I've tried to
perform CLUSTER on it, but seemed to be taking forever (3 hours and still
not completed). So I cancelled it and went with database drop and restore.
It resulted in database taking up 6.4Gb instead of 10Gb. This is a good
improvement, but still isn't quite what I expect. I would appreciate some
clarification.