RES: benchmark

Thanks a lot! But I do not think this is so meaningful to show
at my company:

The bosses need sheets.

"osdb"
"Invoked: bin/osdb-pg --logfile leo.log"
create_tables() 0.34 seconds return value = 0
load() 11.52 seconds return value = 0
create_idx_uniques_key_bt() 2.74 seconds return value = 0
create_idx_updates_key_bt() 3.20 seconds return value = 0
create_idx_hundred_key_bt() 2.91 seconds return value = 0
create_idx_tenpct_key_bt() 2.88 seconds return value = 0
create_idx_tenpct_key_code_bt() 0.73 seconds return value = 0
create_idx_tiny_key_bt() 0.14 seconds return value = 0
create_idx_tenpct_int_bt() 0.47 seconds return value = 0
create_idx_tenpct_signed_bt() 0.48 seconds return value = 0
create_idx_uniques_code_h() 0.82 seconds return value = 0
create_idx_tenpct_double_bt() 0.58 seconds return value = 0
create_idx_updates_decim_bt() 1.23 seconds return value = 0
create_idx_tenpct_float_bt() 0.57 seconds return value = 0
create_idx_updates_int_bt() 0.35 seconds return value = 0
create_idx_tenpct_decim_bt() 0.84 seconds return value = 0
create_idx_hundred_code_h() 1.36 seconds return value = 0
create_idx_tenpct_name_h() 0.81 seconds return value = 0
create_idx_updates_code_h() 1.04 seconds return value = 0
create_idx_tenpct_code_h() 0.65 seconds return value = 0
create_idx_updates_double_bt() 0.51 seconds return value = 0
create_idx_hundred_foreign() 8.07 seconds return value = 0
populateDataBase() 42.25 seconds return value = 0

"Logical database size 4MB"

sel_1_cl() 0.04 seconds return value = 1
join_3_cl() 0.09 seconds return value = 0
sel_100_ncl() 0.16 seconds return value = 100
table_scan() 0.25 seconds return value = 0
agg_func() 1.80 seconds return value = 100
agg_scal() 0.11 seconds return value = 0
sel_100_cl() 0.22 seconds return value = 100
join_3_ncl() 1.74 seconds return value = 1
sel_10pct_ncl() 1.12 seconds return value = 1000
agg_simple_report() 3.96 seconds return value = 990099010
agg_info_retrieval() 0.10 seconds return value = 0
agg_create_view() 0.14 seconds return value = 0
agg_subtotal_report() 0.70 seconds return value = 100
agg_total_report() 0.49 seconds return value = 52789278
join_2_cl() 0.02 seconds return value = 0
join_2() 0.56 seconds return value = 100
sel_variable_select_low() 0.13 seconds return value = 0
sel_variable_select_high() 2.46 seconds return value = 2500
join_4_cl() 0.03 seconds return value = 0
proj_100() 5.81 seconds return value = 6402
join_4_ncl() 2.65 seconds return value = 1
proj_10pct() 7.62 seconds return value = 10000
sel_1_ncl() 0.07 seconds return value = 1
join_2_ncl() 0.10 seconds return value = 1
integrity_test() 0.28 seconds return value = 0
drop_updates_keys() 0.11 seconds return value = 0
bulk_save() 0.32 seconds return value = 0
bulk_modify() 67.37 seconds return value = 0
upd_append_duplicate() 0.02 seconds return value = 0
upd_remove_duplicate() 0.00 seconds return value = 0
upd_app_t_mid() 0.01 seconds return value = 1
upd_mod_t_mid() 0.08 seconds return value = 0
upd_del_t_mid() 0.07 seconds return value = 0
upd_app_t_end() 0.01 seconds return value = 1
upd_mod_t_end() 0.08 seconds return value = 0
upd_del_t_end() 0.07 seconds return value = 0
create_idx_updates_code_h() 0.92 seconds return value = 0
upd_app_t_mid() 0.01 seconds return value = 1
upd_mod_t_cod() 0.02 seconds return value = 0
upd_del_t_mid() 0.07 seconds return value = 0
create_idx_updates_int_bt() 0.36 seconds return value = 0
upd_app_t_mid() 0.02 seconds return value = 1
upd_mod_t_int() 0.03 seconds return value = 0
upd_del_t_mid() 0.07 seconds return value = 0
bulk_append() 0.81 seconds return value = 0
bulk_delete() 66.97 seconds return value = 0

"Single User Test" 168.12 seconds (0:02:48.12)

"Executing multi-user tests with 1 user task"
Mixed IR (tup/sec) 79.53 returned in 5.00 minutes
sel_1_ncl() 0.07 seconds return value = 1
agg_simple_report() 3.81 seconds return value = 990099010
mu_sel_100_seq() 0.30 seconds return value = 0
mu_sel_100_rand() 0.11 seconds return value = 0
mu_mod_100_seq_abort() 0.53 seconds return value = 0
mu_mod_100_rand() 0.16 seconds return value = 0
mu_unmod_100_seq() 0.12 seconds return value = 0
mu_unmod_100_rand() 0.14 seconds return value = 0
crossSectionTests(Mixed IR) 5.27
mu_checkmod_100_seq() 0.93 seconds return value = 100
mu_checkmod_100_rand() 0.74 seconds return value = 100
Mixed OLTP (tup/sec) 127.39 returned in 5.00 minutes
sel_1_ncl() 0.39 seconds return value = 1
agg_simple_report() 16.55 seconds return value = 990099010
mu_sel_100_seq() 0.50 seconds return value = 0
mu_sel_100_rand() 0.17 seconds return value = 0
mu_mod_100_seq_abort() 0.47 seconds return value = 0
mu_mod_100_rand() 0.26 seconds return value = 0
mu_unmod_100_seq() 0.13 seconds return value = 0
mu_unmod_100_rand() 0.14 seconds return value = 0
crossSectionTests(Mixed OLTP) 18.64
mu_checkmod_100_seq() 2.39 seconds return value = 100
mu_checkmod_100_rand() 1.14 seconds return value = 100

"Multi-User Test" 2435.89 seconds (0:40:35.89)




-----Mensagem original-----
De: Brickley Jeff-RA9607 [mailto:Jeff(dot)Brickley(at)motorola(dot)com]
Enviada em: segunda-feira, 16 de setembro de 2002 17:01
Para: 'Elielson Fontanezi'
Assunto: RE: [ADMIN] benchmark

There is a great benchmarking suite for Postgresql. It is called Open
Source Database Benchmar.
You can find it here:
http://osdb.sourceforge.net/ <http://osdb.sourceforge.net/>

Jeff

-----Original Message-----
From: Elielson Fontanezi [mailto:ElielsonF(at)prodam(dot)sp(dot)gov(dot)br]
Sent: Monday, September 16, 2002 2:16 PM
To: pgsql-admin
Subject: [ADMIN] benchmark

Hi everybody!

I am interested to do a benchmark against PostgreSQL 7.2 on Linux RH
7.2.
I would like to know from you, good dba´s, where can I start from.
Where can I found a good benchmark? and Who of you have just did that.

Thanks.

..............................................
A Question...
Since before your sun burned hot in space
and before your race was born,
I have awaited a question.

Elielson Fontanezi
DBA Technical Support - PRODAM
Parque do Ibirapuera s/n - SP - BRAZIL
+55 11 5080 9493