A good project for the Google summer of code would be to solve the aggregate problems in PostgreSQL. In addition, add some of the more complex operators such as rollup and etc. These features can help close the gap between PostgreSQL and popular commercial offerings such as Oracle and DB2.