Home   >   mailing lists

Thread: need help on tuning tpch

need help on tuning tpch

From

"Luis Alberto Amigo Navarro"

Date:

11 March 2002, 07:43:27

We are running a tpc-H benchmark and we need help on tuning this benchmark, the running set consists on an arbitrary number of streams of 22 ad-hoc queries while the system under test is receiving continuos inserts and deletes, here are the tables:

 

Attachment

• supplier.sql
• customer.sql
• indices.sql
• lineitem.sql
• nation.sql
• orders.sql
• part.sql
• partsupp.sql
• region.sql

Re: need help on tuning tpch

From

"Luis Alberto Amigo Navarro"

Date:

12 March 2002, 06:06:18

I mean, is there any mistake on triggers or any possible improve in indices.sql to make it work better, we're using an 8 r10000 powerchallenge, and results become steady from 5 streams and over.

thanks in advance

bad performance on SMP

From

"Luis Alberto Amigo Navarro"

Date:

12 March 2002, 14:31:57

We're running on a 8 r10000 powerchallenge, and results improve from 1 to 5 streams, but from 5 and above results become steady, machine usages reports it's able to manage more workload.

We're running postgres 7.2, it has about 640Mb of shared memory.

Any tip?

Thank in advance