Re: [PERFORM] dbt-2 tuning results with postgresql-8.3.5

2008-12-20 Thread Gregory Stark
"Mark Wong" writes: > To recap, dbt2 is a fair-use derivative of the TPC-C benchmark. We > are using a 1000 warehouse database, which amounts to about 100GB of > raw text data. Really? Do you get conforming results with 1,000 warehouses? What's the 95th percentile response time? -- Gregory

[PERFORM] dbt-2 tuning results with postgresql-8.3.5

2008-12-20 Thread Mark Wong
Hi all, So after a long hiatus after running this OLTP workload at the OSDL, many of you know the community has had some equipment donated by HP: a DL380 G5 and an MSA70 disk array. We are currently using the hardware to do some tuning exercises to show the effects of various GUC parameters. I w