create-pg-Linux_2.2.14_my_SMP_i686-cmp-mysql,pg 911 Bytes
Newer Older
unknown's avatar
unknown committed
1
Testing server 'PostgreSQL version ???' at 2000-12-05  5:49:26
2 3 4 5 6

Testing the speed of creating and droping tables
Testing with 10000 tables and 10000 loop count

Testing create of tables
unknown's avatar
unknown committed
7
Time for create_MANY_tables (10000): 448 wallclock secs ( 7.42 usr  0.95 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
8 9

Accessing tables
unknown's avatar
unknown committed
10
Time to select_group_when_MANY_tables (10000): 187 wallclock secs ( 2.71 usr  0.68 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
11 12

Testing drop
unknown's avatar
unknown committed
13
Time for drop_table_when_MANY_tables (10000): 1324 wallclock secs ( 3.41 usr  0.51 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
14 15

Testing create+drop
unknown's avatar
unknown committed
16 17 18
Time for create+drop (10000): 2954 wallclock secs (11.24 usr  1.81 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Time for create_key+drop (10000): 4055 wallclock secs (10.98 usr  1.30 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
Total time: 8968 wallclock secs (35.76 usr  5.26 sys +  0.00 cusr  0.00 csys =  0.00 CPU)