Benchmarks and Workloads with PostgreSQL
EAStress
EAStress is the research workload based on SpecJAppServer. The metrics of EAStress is not comparable with SpecJAppServer but provides a great workload to stress test database also.
TPC-E
TPC-E is an OLTP workload
TPC-H
TPC-H is a DSS workload
SysBench
SysBench is a popular benchmark which originated in the mySQL community. It also supports PostgreSQL
For a quick how-to guide to run Sysbench using PostgreSQL backend please refer to Jignesh Shah's Blog Entry on SysBench