Yohanes Santoso wrote:
I then ran it on various database size on a software 2 7200RPM IDE RAID-1 volume. I found out that if the dbase size (as from du <dbase_dir>) is less than about 500M, I got a ratio of 4.5:1. On a larger dbase, 3GB, the ratio increases to 10:1.
Surely this is going to be a function of table size, not database size, isn't it? Did you scale up the size of tables to get your 3Gb database?
cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq