continuing daily testing of dbt3 against postgresql

From: Mark Wong <markw(at)osdl(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: continuing daily testing of dbt3 against postgresql
Date: 2006-10-09 18:47:19
Message-ID: 452A9937.2070704@osdl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-09 18:57:39 Re: width_bucket function for timestamps
Previous Message Josh Berkus 2006-10-09 18:43:09 Re: [PATCHES] Generic Monitoring Framework with DTrace patch