pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAny public dataset for benchmarking?
3+ messages / 3 participants
[nested] [flat]
* Any public dataset for benchmarking?
@ 2012-05-01 09:13 Bèrto ëd Sèra <berto.d.sera@gmail.com>
2012-05-01 15:06 ` Re: Any public dataset for benchmarking? Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 1 reply; 3+ messages in thread
From: Bèrto ëd Sèra @ 2012-05-01 09:13 UTC (permalink / raw)
To: pgsql-admin
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...).
All suggestions welcome
Bèrto
--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a
darkened room munching pills and listening to repetitive music.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Any public dataset for benchmarking?
2012-05-01 09:13 Any public dataset for benchmarking? Bèrto ëd Sèra <berto.d.sera@gmail.com>
@ 2012-05-01 15:06 ` Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 0 replies; 3+ messages in thread
From: Thomas Kellerer @ 2012-05-01 15:06 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Any public dataset for benchmarking?
@ 2012-05-01 12:15 Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 3+ messages in thread
From: Kevin Grittner @ 2012-05-01 12:15 UTC (permalink / raw)
To: berto.d.sera@gmail.com; pgsql-admin
Bèrto ëd Sèra wrote:
> I'm asked to benchmark a PG-related product. I was wondering if
> there is any "sort of standard" public dataset for such operations.
You might want to take a look at pgbench:
http://www.postgresql.org/docs/9.1/interactive/pgbench.html
-Kevin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-05-01 15:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-05-01 09:13 Any public dataset for benchmarking? Bèrto ëd Sèra <berto.d.sera@gmail.com>
2012-05-01 15:06 ` Thomas Kellerer <spam_eater@gmx.net>
2012-05-01 12:15 Re: Any public dataset for benchmarking? Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox