I've upgraded RubyForge to PostgreSQL 8.2. A couple of notes:
- The database is at about 18 million records
- It took around 6 minutes to dump and 8 minutes to restore.
- The dump/restore resulted in the disk space for the data directory going from 6.6 GB to 2.2 GB
- After the restore, I did a vacuumdb --full --analyze. That took around 3 minutes.
Overall, 8.2 seems great. I've got a little script that does a full record count; that script used to take around 2 minutes and now it runs in 5 or 6 seconds! And more importantly, the site seems snappy... good times.
