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