Testing server 'PostgreSQL version 7.1.2' at 2001-06-12 15:10:04

Testing the speed of selecting on keys that consist of many parts
The test-table has 10000 rows and the test is done with 500 ranges.

Creating table
Inserting 10000 rows
Time to insert (10000):  9 wallclock secs ( 2.91 usr  0.30 sys +  0.00 cusr  0.00 csys =  3.21 CPU)

Test if the database has a query cache
Time for select_query_cache (10000): 2623 wallclock secs ( 3.22 usr  0.37 sys +  0.00 cusr  0.00 csys =  3.59 CPU)

Time for select_query_cache2 (10000): 2622 wallclock secs ( 2.73 usr  0.47 sys +  0.00 cusr  0.00 csys =  3.20 CPU)

Testing big selects on the table
Time for select_big (70:17207):  1 wallclock secs ( 0.12 usr  0.01 sys +  0.00 cusr  0.00 csys =  0.13 CPU)
Time for select_range (410:1057904): 491 wallclock secs (11.40 usr  0.50 sys +  0.00 cusr  0.00 csys = 11.90 CPU)
Note: Query took longer then time-limit: 600
Estimating end time based on:
11893 queries in 1699 loops of 10000 loops took 601 seconds
Estimated time for min_max_on_key (70000): 3537 wallclock secs (21.54 usr  3.06 sys +  0.00 cusr  0.00 csys = 24.60 CPU)
Note: Query took longer then time-limit: 600
Estimating end time based on:
17720 queries in 3544 loops of 10000 loops took 601 seconds
Estimated time for count_on_key (50000): 1695 wallclock secs (15.49 usr  2.14 sys +  0.00 cusr  0.00 csys = 17.64 CPU)

Time for count_group_on_key_parts (1000:100000): 332 wallclock secs ( 1.20 usr  0.04 sys +  0.00 cusr  0.00 csys =  1.24 CPU)
Testing count(distinct) on the table
Time for count_distinct_key_prefix (1000:1000): 188 wallclock secs ( 0.33 usr  0.05 sys +  0.00 cusr  0.00 csys =  0.38 CPU)
Time for count_distinct (1000:1000): 131 wallclock secs ( 0.29 usr  0.02 sys +  0.00 cusr  0.00 csys =  0.31 CPU)
Time for count_distinct_2 (1000:1000): 213 wallclock secs ( 0.43 usr  0.06 sys +  0.00 cusr  0.00 csys =  0.49 CPU)
Time for count_distinct_group_on_key (1000:6000): 485 wallclock secs ( 0.38 usr  0.03 sys +  0.00 cusr  0.00 csys =  0.41 CPU)
Time for count_distinct_group_on_key_parts (1000:100000): 381 wallclock secs ( 1.23 usr  0.05 sys +  0.00 cusr  0.00 csys =  1.28 CPU)
Time for count_distinct_group (1000:100000): 384 wallclock secs ( 1.12 usr  0.07 sys +  0.00 cusr  0.00 csys =  1.19 CPU)
Time for count_distinct_big (100:1000000): 65 wallclock secs ( 8.50 usr  0.17 sys +  0.00 cusr  0.00 csys =  8.67 CPU)
Estimated total time: 13160 wallclock secs (70.90 usr  7.35 sys +  0.00 cusr  0.00 csys = 78.25 CPU)
