Hello,
I found this: http://www.postgresql.org/community/survey.32
However, I think one of the bests improvement is that you don't have to
typecast every value in pgsql8 to force it using indexes.
Casting int4 values to int8 in case of bigint primary key was so
annoying in 7.4.
Mage