After loading 2 tables (pi1, pi2) with 5M rows each

gistfile1.txt

pi1_pkey
-[ RECORD 1 ]------+----------
version            | 4
tree_level         | 2
index_size         | 112328704
root_block_no      | 412
internal_pages     | 49
leaf_pages         | 13662
empty_pages        | 0
deleted_pages      | 0
avg_leaf_density   | 90.08
leaf_fragmentation | 0

pi1_pdc
-[ RECORD 1 ]------+----------
version            | 4
tree_level         | 2
index_size         | 265986048
root_block_no      | 412
internal_pages     | 150
leaf_pages         | 32318
empty_pages        | 0
deleted_pages      | 0
avg_leaf_density   | 68.67
leaf_fragmentation | 48.29

pi1_marketsegment
-[ RECORD 1 ]------+----------
version            | 4
tree_level         | 2
index_size         | 149536768
root_block_no      | 412
internal_pages     | 55
leaf_pages         | 18198
empty_pages        | 0
deleted_pages      | 0
avg_leaf_density   | 67.7
leaf_fragmentation | 50.05

pi1_registersegment
-[ RECORD 1 ]------+----------
version            | 4
tree_level         | 2
index_size         | 205897728
root_block_no      | 412
internal_pages     | 92
leaf_pages         | 25041
empty_pages        | 0
deleted_pages      | 0
avg_leaf_density   | 68.88
leaf_fragmentation | 49.86