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

RES: benchmark

From: Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>
To: 'Brickley Jeff-RA9607' <Jeff(dot)Brickley(at)motorola(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: RES: benchmark
Date: 2002-09-17 17:16:33
Message-ID: A799F7647794D311924A005004ACEA9708A2458F@cprodamibs249.prodam (view raw or flat)
Thread:
Lists: pgsql-admin
 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 

 

pgsql-admin by date

Next:From: Elielson FontaneziDate: 2002-09-17 18:50:24
Subject: Other benchmark than OSDB
Previous:From: Darren FergusonDate: 2002-09-17 15:26:26
Subject: Re: Copying table to another database.

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