To: pgsql-admin@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: Any public dataset for benchmarking?
Date: Tue, 01 May 2012 17:06:54 +0200
Lines: 17
Message-ID: <jnou4t$u2j$1@dough.gmane.org>
References: 
 <CAKwGa_-gRQ5hon=kizd_GDMaqbmGBB=MuFtcAVD_SK+jrT4bow@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de;
	rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To: 
 <CAKwGa_-gRQ5hon=kizd_GDMaqbmGBB=MuFtcAVD_SK+jrT4bow@mail.gmail.com>

Bèrto ëd Sèra wrote on 01.05.2012 11:13:
> Hi all,
>
> I'm asked to benchmark a PG-related product. I was wondering if there
> is any "sort of standard" public dataset for such operations. The one
> and only limit I have is I cannot use triggers with this product
> (otherwise I'd use a copy of our own production datasets and everyone
> would be happy, but this is the life...).
>

Have a look at the DellStore2 benchmark suite

http://linux.dell.com/dvdstore/

it supports PostgreSQL (since last year) and generating the dataset is quite straighforward - although I couldn't get the actual benchmark program to run on Windows.