Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] Dbt2 with postgres issues on CentOS-5.?==?UTF-8?Q?3‏

From: Mark Wong <markwkm(at)gmail(dot)com>
To: MUHAMMAD ASIF <anaeem(dot)it(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Dbt2 with postgres issues on CentOS-5.?==?UTF-8?Q?3‏
Date: 2010-04-22 01:10:35
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
2010/4/20 MUHAMMAD ASIF <anaeem(dot)it(at)hotmail(dot)com>:
> Hi,
> I am using dbt2 on Linux 64 (CentOS release 5.3 (Final)) . I have compiled
> latest postgresql-8.4.3 code on the machine and run dbt2 against it. I am
> little confused about the results. I ran dbt2 with the following
> configuration i.e.
> DBT2 Options :
> DBT2 Command :
>         ./dbt2-pgsql-create-db
>         ./dbt2-pgsql-build-db -d $DBDATA -g -r -w $WAREHOUSES
>         ./dbt2-run-workload -a pgsql -c $DB_CONNECTIONS -d
>         ./dbt2-pgsql-stop-db
> I am not able to understand the sar related graphs. Iostat,mpstat and vmstat
> results are similar but
>   sar results are strange. I tried to explore the dbt2 source code to find
> out the how graphs are drawn and why sar results : 189 reads
> sar.out and parse it and consider 1 minute elapsed time between each record
> i.e.

That is certainly a weakness in the logic of the perl modules in
plotting the charts accurately.  I wouldn't be surprised if the other
stat tools suffer the same problem.


In response to


pgsql-performance by date

Next:From: Scott CareyDate: 2010-04-22 01:21:10
Subject: Re: Very high effective_cache_size == worse performance?
Previous:From: Eliot GableDate: 2010-04-21 20:16:18
Subject: Replacing Cursors with Temporary Tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group