Just want to share the DBT(2&5) thing http://archives.postgresql.org/pgsql-performance/2011-04/msg00145.php http://sourceforge.net/mailarchive/forum.php?forum_name=osdldbt-general&max_rows=25&style=nested&viewmonth=201104
On Wed, Apr 27, 2011 at 11:55 PM, Greg Smith <g...@2ndquadrant.com> wrote: > Tomas Vondra wrote: > >> Hmmm, just wondering - what would be needed to build such 'workload >> library'? Building it from scratch is not feasible IMHO, but I guess >> people could provide their own scripts (as simple as 'set up a a bunch >> of tables, fill it with data, run some queries') and there's a pile of >> such examples in the pgsql-performance list. >> >> > > The easiest place to start is by re-using the work already done by the TPC > for benchmarking commercial databases. There are ports of the TPC workloads > to PostgreSQL available in the DBT-2, DBT-3, and DBT-5 tests; see > http://wiki.postgresql.org/wiki/Category:Benchmarking for initial > information on those (the page on TPC-H is quite relevant too). I'd like to > see all three of those DBT tests running regularly, as well as two tests > it's possible to simulate with pgbench or sysbench: an in-cache read-only > test, and a write as fast as possible test. > > The main problem with re-using posts from this list for workload testing is > getting an appropriately sized data set for them that stays relevant. The > nature of this sort of benchmark always includes some notion of the size of > the database, and you get different results based on how large things are > relative to RAM and the database parameters. That said, some sort of > systematic collection of "hard queries" would also be a very useful project > for someone to take on. > > People show up regularly who want to play with the optimizer in some way. > It's still possible to do that by targeting specific queries you want to > accelerate, where it's obvious (or, more likely, hard but still > straightforward) how to do better. But I don't think any of these proposed > exercises adjusting the caching model or default optimizer parameters in the > database is going anywhere without some sort of benchmarking framework for > evaluating the results. And the TPC tests are a reasonable place to start. > They're a good mixed set of queries, and improving results on those does > turn into a real commercial benefit to PostgreSQL in the future too. > > > -- > Greg Smith 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD > PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us > "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >