Re: continuing daily testing of dbt3 against postgresql

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Mark Wong <markw(at)osdl(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: continuing daily testing of dbt3 against postgresql
Date: 2006-10-09 19:15:37
Message-ID: 452A9FD9.20207@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-09 19:22:30 Re: OT: Is there a LinkedIn group for Postgresql?
Previous Message Jim C. Nasby 2006-10-09 18:57:39 Re: width_bucket function for timestamps