[Bizgres-general] [ENG] Re: Statement Queuing take II - Resource Scheduling (Running)

Luke Lonergan LLonergan at greenplum.com
Tue Jul 18 01:47:11 UTC 2006


Mark,
 
> No, no yet. I did try out the dbt-3 benchmark, altho I spent 
> most of the time removing Redhaterisms so it would run on 
> Gentoo.. :-(.

Cool!  The level of concurrency is much lower (5-9 streams) on DBT-3
than on pgbench and it's much more to the point.

The interesting case would be to run 6 streams all at once, then
separate the sorting queries out and run them in a separate queue from
the others and see the improvement in runtime (should be 3-5x).

- Luke



More information about the Bizgres-general mailing list