Hi all,

Just wanted to share some information I was pointed to in case no one has heard:

The kit can be found here:
http://www.infor.uva.es/~diego/tpcc-uva.html

The SIGMOD paper is here:
http://www.sigmod.org/sigmod/record/...cle-llanos.pdf

Mark

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

On 3/2/07, Mark Wong <markwkm@gmail.com> wrote:
> Just wanted to share some information I was pointed to in case no one has heard:

Yep, tpcc-uva is pretty good. I've played with it for over a year now.

The only issue with it is that it currently has a 128 warehouse limit.

--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Jonah H. Harris wrote:
> On 3/2/07, Mark Wong <markwkm@gmail.com> wrote:
>> Just wanted to share some information I was pointed to in case no one
>> has heard:
>
> Yep, tpcc-uva is pretty good. I've played with it for over a year now.
>
> The only issue with it is that it currently has a 128 warehouse limit.
>
There is also odbc-bench which I was thinking about automating.

J


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On 3/2/07, Joshua D. Drake <jd@commandprompt.com> wrote:
> There is also odbc-bench which I was thinking about automating.

Yep, OpenLink's ODBC Bench is pretty good for both TPC-A and TPC-C.
Unfortunately their JDBCBench needs a lot of work.

--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Jonah H. Harris wrote:
> On 3/2/07, Joshua D. Drake <jd@commandprompt.com> wrote:
>> There is also odbc-bench which I was thinking about automating.
>
> Yep, OpenLink's ODBC Bench is pretty good for both TPC-A and TPC-C.

I haven't ported it yet but I like the fact that it has stored
procedures ability as well as just transactions.

Joshua D. Drake

> Unfortunately their JDBCBench needs a lot of work.
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

On 3/2/07, Joshua D. Drake <jd@commandprompt.com> wrote:
> Jonah H. Harris wrote:
> > On 3/2/07, Joshua D. Drake <jd@commandprompt.com> wrote:
> >> There is also odbc-bench which I was thinking about automating.
> >
> > Yep, OpenLink's ODBC Bench is pretty good for both TPC-A and TPC-C.
>
> I haven't ported it yet but I like the fact that it has stored
> procedures ability as well as just transactions.
>
> Joshua D. Drake
>
> > Unfortunately their JDBCBench needs a lot of work.
> >

Cool. Let me know if you see any TPC-E implementations. I'm working
with Rilson to improve the one he started.

Mark

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly