How can I generate TPC-DS queries for PostgreSQL?
Not sure about the TPC-DS, but I know that HammerDB will perform a TPC-H(ad hoc DSS) benchmark test against PostgreSQL.  If you're looking for a benchmark, but not specifically a TPC-DS, this is a good tool for testing.