create-pg_fast-linux_2.4.2_64gb_smp_i686-cmp-mysql,pg

开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip

Testing server 'PostgreSQL version 7.1.2' at 2001-06-12  1:48:52

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

Testing create of tables
Time for create_MANY_tables (5000): 194 wallclock secs ( 6.27 usr  5.72 sys +  0.00 cusr  0.00 csys = 11.99 CPU)

Accessing tables
Time to select_group_when_MANY_tables (5000): 14 wallclock secs ( 1.46 usr  0.28 sys +  0.00 cusr  0.00 csys =  1.74 CPU)

Testing drop
Time for drop_table_when_MANY_tables (5000): 599 wallclock secs ( 1.39 usr  0.38 sys +  0.00 cusr  0.00 csys =  1.77 CPU)

Testing create+drop
Time for create+drop (10000): 2924 wallclock secs (11.10 usr  2.41 sys +  0.00 cusr  0.00 csys = 13.51 CPU)
Time for create_key+drop (10000): 5464 wallclock secs (11.00 usr  2.30 sys +  0.00 cusr  0.00 csys = 13.30 CPU)
Total time: 9195 wallclock secs (31.22 usr 11.10 sys +  0.00 cusr  0.00 csys = 42.32 CPU)