linux Ubuntu 64 bit
gcc 64 bits


== Query A ==
/usr/local/pgsql/bin/psql -U postgres -f /home/ranier/Documentos/benchmarks/bitmapset/create-tables-a.sql
/usr/local/pgsql/bin/psql -U postgres -f /home/ranier/Documentos/benchmarks/bitmapset/query-a.sql
=============


head:
Time: 1809,993 ms (00:01,810)
Time: 1772,793 ms (00:01,773)
Time: 1769,734 ms (00:01,770)

patched v4:
Time: 933,181 ms
Time: 931,520 ms
Time: 906,496 ms
Time: 872,446 ms

patched v7 (backward):
Time: 721,305 ms
Time: 720,289 ms
Time: 716,932 ms
Time: 715,405 ms

patched v7 (forward):
Time: 978,344 ms
Time: 942,889 ms
Time: 878,150 ms
Time: 877,747 ms

patched v7 (without "spurious test"):
Time: 790,336 ms
Time: 788,384 ms
Time: 787,970 ms
Time: 787,040 ms


== Query B ==
/usr/local/pgsql/bin/psql -U postgres -f /home/ranier/Documentos/benchmarks/bitmapset/create-tables-b.sql
/usr/local/pgsql/bin/psql -U postgres -f /home/ranier/Documentos/benchmarks/bitmapset/query-b.sql


patched v4:
Time: 1581,317 ms (00:01,581)
Time: 1568,371 ms (00:01,568)
Time: 1468,036 ms (00:01,468)
Time: 1445,698 ms (00:01,446)

patched v7 (backward):
Time: 1326,782 ms (00:01,327)
Time: 1322,362 ms (00:01,322)
Time: 1321,670 ms (00:01,322)
Time: 1319,427 ms (00:01,319)

patched v7 (forward):
Time: 1487,447 ms (00:01,487)
Time: 1477,957 ms (00:01,478)
Time: 1470,305 ms (00:01,470)
Time: 1466,994 ms (00:01,467)

patched v7 (without "spurious test"):
Time: 1458,915 ms (00:01,459)
Time: 1455,686 ms (00:01,456)
Time: 1451,509 ms (00:01,452)
Time: 1444,873 ms (00:01,445)