help on tpch benchmark

From: "Luis Alberto Amigo Navarro" <lamigo(at)atc(dot)unican(dot)es>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: help on tpch benchmark
Date: 2002-03-08 19:05:35
Message-ID: 005001c1c6d4$3a864910$cab990c1@atc.unican.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Attachment Content-Type Size
supplier.sql application/octet-stream 267 bytes
customer.sql application/octet-stream 289 bytes
lineitem.sql application/octet-stream 2.2 KB
nation.sql application/octet-stream 211 bytes
orders.sql application/octet-stream 318 bytes
part.sql application/octet-stream 591 bytes
partsupp.sql application/octet-stream 321 bytes
region.sql application/octet-stream 103 bytes
indices.sql application/octet-stream 895 bytes

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-03-08 19:37:32 Re: UB-Tree
Previous Message Zeugswetter Andreas SB SD 2002-03-08 18:06:55 Re: Index USING in pg_dump