Home > mailing lists

help on tpch benchmark - Mailing list pgsql-hackers

From	Luis Alberto Amigo Navarro
Subject	help on tpch benchmark
Date	March 13, 2002 13:46:39
Msg-id	005001c1c6d4$3a864910$cab990c1@atc.unican.es Whole thread Raw
List	pgsql-hackers

hi all.

We have done a like tpch benchmark and we would like to have some performance tips.

the benchmark is based on this database:

we are creating indexes on indeices.sql

There are 22 ad-hoc queries running on diferent streams while there are concurrent insertions and deletes, numeric are part of the specifications.

Are there any tips?

thanks in advance

From: "Adam Wyard"
Date: 13 March 2002, 13:40:17
Subject: Update 6.5 database files to 7.0

From: "Luis Alberto Amigo Navarro"
Date: 13 March 2002, 13:47:59
Subject: Re: bad performance on irix