Re: [PERFORM] dbt2 performance

2010-02-25 Thread Yu-Ju Hong
Thanks for the reply. On Thu, Feb 25, 2010 at 5:48 PM, Greg Smith wrote: > Yu-Ju Hong wrote: > >> 2. Moreover, the disk utilization was high and the "await" time from >> iostat is around 500 ms. Could disk I/O limit the overall throughput? The >> server ha

[PERFORM] dbt2 performance

2010-02-25 Thread Yu-Ju Hong
Hi, I have a couple of questions about dbt2 performance. 1. I tested dbt2+postgresql 8.4.2 on my server, but the NOTPM is around only 320~390 with 10 connections and 30 warehouses. Increasing the number of connections did not improve the throughput? The NOPTM number does not seem very high to me.