RubyForge on PostgreSQL 8.2

11 Dec 2006

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.