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 |
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 |