continuing daily testing of dbt3 against postgresql

Started by Mark Wongover 19 years ago2 messages
#1Mark Wong
markw@osdl.org

Hi everyone,

I have now resumed producing daily results of dbt-3 against PostgreSQL
CVS code at the 10 GB scale factor with results here:
http://dbt.osdl.org/dbt3.html

I'm currently only running the load the power test because of the amount
of time it takes to run through the power test. The load test finishes
within an hour while a power test finished in about 14 hours.
Additionally the refresh streams are not executed. The two longest
running queries are currently Q9 (~ 7 hours) and Q21 (~ 3 hours).

EXPLAIN output can be found for each individual query by following the
"Power Test" then "query plans" links on the bottom of a test result's
page. EXPLAIN ANALYZE output can be found on the "query results" link
under the "query plans" link.

I'm still working on generating a more concise iostat report but a
description of the disk layout can be found on the url listed above.

Regards,
Mark

#2Stefan Kaltenbrunner
stefan@kaltenbrunner.cc
In reply to: Mark Wong (#1)
Re: continuing daily testing of dbt3 against postgresql

Mark Wong wrote:

Hi everyone,

I have now resumed producing daily results of dbt-3 against PostgreSQL
CVS code at the 10 GB scale factor with results here:
http://dbt.osdl.org/dbt3.html

I'm currently only running the load the power test because of the amount
of time it takes to run through the power test. The load test finishes
within an hour while a power test finished in about 14 hours.
Additionally the refresh streams are not executed. The two longest
running queries are currently Q9 (~ 7 hours) and Q21 (~ 3 hours).

FWIW: that findings roughly match with the testing I did several weeks
ago but the two fixes tom put in after that already improved the
situation but there is still a lot to do there :-(

Stefan