need help on tuning tpch

From: "Luis Alberto Amigo Navarro" <lamigo(at)atc(dot)unican(dot)es>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: need help on tuning tpch
Date: 2002-03-11 09:45:22
Message-ID: 00c501c1c8e1$76abc550$cab990c1@atc.unican.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 Content-Type Size
supplier.sql application/octet-stream 267 bytes
customer.sql application/octet-stream 289 bytes
indices.sql application/octet-stream 895 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Schrem 2002-03-11 09:55:49 Fwd: Re: UB-Tree
Previous Message karin probost 2002-03-11 08:30:18 Operator ~ on type aclitem in pgsql 7.2