Re: continuing daily testing of dbt3 against postgresql - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject Re: continuing daily testing of dbt3 against postgresql
Date
Msg-id 452A9FD9.20207@kaltenbrunner.cc
Whole thread Raw
In response to continuing daily testing of dbt3 against postgresql  (Mark Wong <markw@osdl.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: width_bucket function for timestamps
Next
From: "Jim C. Nasby"
Date:
Subject: Re: OT: Is there a LinkedIn group for Postgresql?