There's an impressive list of new features and improvements, performance enhancements included.
Some of the new features are quite interesting. Full text search right there in the database. Would it be useful for a Webshop, a CMS, etc?
XML is now also right there in the DB. I have to play with this. I have a schema with descriptions of rows and columns for financial reports. Ordinary database row definition is a poor match for this. Perhaps SQL/XML will solve this problem.
Enums may make all these small support tables obsolete. We'll see.
And finally (on today's list, there are many more news in 8.3) we have updatable cursors. I hope it will occur in DBD::Pg as soon as possible.
8.3 really excites me.