PostgreSQL has a lot of really great features, but some things are seriously underdeveloped as well, mostly because missing man power. You cannot reorder columns of a table easily, it does not support compression of connections (yet), XID-wraparound as others have already said.

I would also personally love map-reduce indexes (for example for efficiently calculating sums or other aggregate functions...)