RES: benchmark

Поиск

Список

Период

Сортировка

От	Elielson Fontanezi
Тема	RES: benchmark
Дата	17 сентября 2002 г. 16:15:49
Msg-id	A799F7647794D311924A005004ACEA9708A2458F@cprodamibs249.prodam обсуждение исходный текст
Список	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.Brickley@motorola.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/

Jeff

-----Original Message-----
From: Elielson Fontanezi [mailto:ElielsonF@prodam.sp.gov.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 по дате отправления:

Предыдущее

От: Andrew Sullivan
Дата: 17 сентября 2002 г., 14:19:42
Сообщение: Re: [GENERAL] Still big problems with pg_dump!

Следующее

От: Elielson Fontanezi
Дата: 17 сентября 2002 г., 17:49:36
Сообщение: Other benchmark than OSDB

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

RES: benchmark

Предыдущее

Следующее