postgresql reference application

Does anyone know of some good open source applications that are using
postgresql well? I am interested in studying schema and physical design
of some well thought out applications. Any suggestions would be
helpful.

thanks,

eric