On Tue, 2006-03-28 at 19:47, sh test wrote: > Hello admins! > > i need to collect as much information > > pro/cons on a possible upgrade from > > 7.4 ---> 8.0/8.1 version > > Aside from getting our users vote on this, I wanted to ask you first > in order to collect any possible issues one might run into from > upgrading to such > versions. Downside: You gotta dump and reload, or use slony to minimize the downtime, but you need a spare machine to do that. Upside: Everything else. PostgreSQL 8.x series has a lot of performance improvements.