Re: Recommended TPC-DS tools/setup for PostgreSQL benchmarking?

Mark Wong <markwkm(at)gmail(dot)com>于2026年2月18日 周三00:45写道：

> On Sun, Feb 15, 2026 at 12:04:18PM +0800, Zhang Mingli wrote:
> > Hi,
> >
> > I'm planning to run TPC-DS benchmarks on PostgreSQL and wanted to ask
> the community about the current recommended approach.
> >
> > Some background: I've been running TPC-DS on Greenplum-based databases
> for a long time using adapted tooling (modified queries, load scripts, etc.
> for the MPP environment).
> > Now I'd like to benchmark on PostgreSQL as well, and I'm wondering
> whether the community has converged on a standard tool or workflow — or if
> everyone is still downloading the official TPC-DS kit and doing their own
> PostgreSQL adaptations.
> >
> > A few specific questions:
> >
> > 1. Is there a commonly-used, well-maintained TPC-DS toolset for
> PostgreSQL? I know some tpcds tools for postgres like
> gregrahn/tpcds-kit(its tpcds version is 2.x, but the newest tpcds version
> is 4.x) on GitHub, but I'm curious if there's anything more "official" or
> widely adopted in the community — something that handles data generation,
> PostgreSQL-compatible DDL, query adaptation, and result collection out of
> the box.
> >
> > 2. TPC-DS is now at version 4.0. Which version of the specification are
> people currently using for PostgreSQL benchmarking? Is there a practical
> reason to prefer an older version (e.g., v2.x or v3.x) over the latest?
> >
> > Any pointers to repos, scripts, wiki pages, or past threads would be
> greatly appreciated.
>
> I try to keep this one maintained and as compliant to the current (4.0)
> specification as I can: https://github.com/osdldbt/dbt7
>
> I'm not sure how widely used it is, but I believe the OSDL kits are not
> known
> to be the easiest to use. :)
>
> Feel free to contact me directly if you have more questions about the kit.

Hi, Mark

Good to know, thank you very much for sharing.