while there are a lot of different improvements, i'm really looking forward to the enhanced JSON functionalities (particularly the new operators [0]) and the LATERAL JOIN [1]
[0] http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-... [1] http://www.postgresql.org/docs/9.3/static/queries-table-expr...