big-tables-pg-Linux_2.4.0_64GB_SMP_i686-cmp-mysql,pg 866 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Testing server 'PostgreSQL version ???' at 2001-06-03  4:42:56

Testing of some unusual tables
All tests are done 1000 times with 1000 fields

Testing table with 1000 fields
Testing select * from table with 1 record
Time to select_many_fields(1000): 338 wallclock secs ( 3.28 usr  0.22 sys +  0.00 cusr  0.00 csys =  3.50 CPU)

Testing select all_fields from table with 1 record
Time to select_many_fields(1000): 457 wallclock secs ( 3.69 usr  0.26 sys +  0.00 cusr  0.00 csys =  3.95 CPU)

Testing insert VALUES()
Time to insert_many_fields(1000): 229 wallclock secs ( 0.40 usr  0.07 sys +  0.00 cusr  0.00 csys =  0.47 CPU)

Testing insert (all_fields) VALUES()
Time to insert_many_fields(1000): 299 wallclock secs ( 0.72 usr  0.14 sys +  0.00 cusr  0.00 csys =  0.86 CPU)

Total time: 1324 wallclock secs ( 8.10 usr  0.69 sys +  0.00 cusr  0.00 csys =  8.79 CPU)