Testing server 'PostgreSQL version ???' at 2001-06-03  4:40:22

ATIS table test

Creating tables
Time for create_table (28):  0 wallclock secs ( 0.01 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.01 CPU)

Inserting data
Time to insert (9768):  8 wallclock secs ( 2.97 usr  0.28 sys +  0.00 cusr  0.00 csys =  3.25 CPU)

Retrieving data
Time for select_simple_join (500):  3 wallclock secs ( 0.74 usr  0.03 sys +  0.00 cusr  0.00 csys =  0.77 CPU)
Time for select_join (100):  4 wallclock secs ( 0.52 usr  0.13 sys +  0.00 cusr  0.00 csys =  0.65 CPU)
Time for select_key_prefix_join (100): 11 wallclock secs ( 4.30 usr  0.16 sys +  0.00 cusr  0.00 csys =  4.46 CPU)
Time for select_distinct (800): 22 wallclock secs ( 1.95 usr  0.18 sys +  0.00 cusr  0.00 csys =  2.13 CPU)
Time for select_group (2600): 52 wallclock secs ( 1.43 usr  0.19 sys +  0.00 cusr  0.00 csys =  1.62 CPU)

Removing tables
Time to drop_table (28):  1 wallclock secs ( 0.01 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.01 CPU)
Total time: 101 wallclock secs (11.93 usr  0.98 sys +  0.00 cusr  0.00 csys = 12.91 CPU)