Re: [osdldbt-general] How long should dbt3 take?

[Mark W. <ma...@gm...>]

On 6/26/07, Mickelson, John K <joh...@in...> wrote:
>
>
>
>
> Hi All,
>
>             I've kicked off a run of dbt3 that's been going for just abou=
t 6
> hours
>
>             on a Dual Xeon system. Any general idea of how long this shou=
ld
> take?
>
>
>
>             I can see via ps =96edf that the same select statement has ea=
ten
> about
>
>             4 hours of CPU time and still going.
>
>
>
>             Am it stuck, or do I need to wait longer?

This sort of workload is certainly not PostgreSQL's strong area and
doesn't perform very well as you increase the scale factor.
Unfortunately the data at OSDL doesn't exist anymore and my memory is
starting to fail me, but I believe a 10 scale factor should complete
within 8 hours.  A scale factor of 1 will complete within an hour.
These results were from an Itanium 2 system.  The only significant
database parameter I can remember setting is default_statistics_target
=3D 1000.  The default of 10 produced very poorly performing plans for
some of the queries.  Hope that helps.

Regards,
Mark