==== BEFORE patch. # = 1 is fixed sized rows, # = 2 is variable sized rows # | del% | pages | n_live_tup | tups est | tups real | est/real | bufs ---+------+-------+------------+----------+-----------+----------+------ 1 | 0.1 | 7523 | 900001 | 941326 | 900001 | 1.046 | 444 1 | 0.2 | 7523 | 800001 | 882465 | 800001 | 1.103 | 886 1 | 0.3 | 7523 | 700001 | 823697 | 700001 | 1.177 | 1329 1 | 0.4 | 7523 | 600001 | 764836 | 600001 | 1.275 | 1771 1 | 0.5 | 7523 | 500001 | 706068 | 500001 | 1.412 | 2214 1 | 0.6 | 7523 | 400001 | 647206 | 400001 | 1.618 | 2656 1 | 0.7 | 4425 | 300001 | 588239 | 300001 | 1.961 | 3099 1 | 0.8 | 4425 | 200001 | 529394 | 200001 | 2.647 | 3542 1 | 0.9 | 4425 | 100001 | 470626 | 100001 | 4.706 | 3985 1 | 0.95 | 4425 | 50001 | 441196 | 50001 | 8.824 | 4206 1 | 0.99 | 4425 | 417670 | 417670 | 10001 | 41.763 | 4383 2 | 0.1 | 1263 | 100000 | 91902 | 90001 | 1.021 | 104 2 | 0.2 | 1263 | 100000 | 83737 | 80001 | 1.047 | 207 2 | 0.3 | 1263 | 100000 | 75573 | 70001 | 1.080 | 310 2 | 0.4 | 1263 | 100000 | 67409 | 60001 | 1.123 | 413 2 | 0.5 | 1263 | 100000 | 59245 | 50001 | 1.185 | 516 2 | 0.6 | 1263 | 100000 | 51099 | 40001 | 1.277 | 620 2 | 0.7 | 541 | 100000 | 42855 | 30001 | 1.428 | 723 2 | 0.8 | 541 | 38607 | 38607 | 20001 | 1.930 | 778 2 | 0.9 | 541 | 100000 | 34321 | 10001 | 3.432 | 832 2 | 0.95 | 541 | 100000 | 34930 | 5001 | 6.985 | 885 2 | 0.99 | 541 | 30930 | 30930 | 1001 | 30.899 | 885 ==== AFTER the patch # | del% | pages | n_live_tup | tups est | tups real | est/real | bufs ---+------+-------+------------+----------+-----------+----------+------ 1 | 0.1 | 7523 | 900001 | 941326 | 900001 | 1.046 | 444 1 | 0.2 | 7523 | 800001 | 803449 | 800001 | 1.004 | 886 1 | 0.3 | 7523 | 700001 | 703835 | 700001 | 1.005 | 1329 1 | 0.4 | 7523 | 600001 | 604220 | 600001 | 1.007 | 1771 1 | 0.5 | 7523 | 500001 | 504606 | 500001 | 1.009 | 2214 1 | 0.6 | 7523 | 400001 | 404992 | 400001 | 1.012 | 2656 1 | 0.7 | 4425 | 300001 | 305340 | 300001 | 1.018 | 3099 1 | 0.8 | 4425 | 205758 | 205758 | 200001 | 1.029 | 3542 1 | 0.9 | 4425 | 106169 | 106169 | 100001 | 1.062 | 3985 1 | 0.95 | 4425 | 56373 | 56373 | 50001 | 1.127 | 4206 1 | 0.99 | 4425 | 10001 | 16535 | 10001 | 1.653 | 4383 2 | 0.1 | 1263 | 100000 | 91902 | 90001 | 1.021 | 104 2 | 0.2 | 1263 | 100000 | 67589 | 80001 | 0.845 | 207 2 | 0.3 | 1263 | 100000 | 57522 | 70001 | 0.822 | 310 2 | 0.4 | 1263 | 60001 | 47489 | 60001 | 0.791 | 413 2 | 0.5 | 1263 | 100000 | 37469 | 50001 | 0.749 | 516 2 | 0.6 | 1263 | 40001 | 27455 | 40001 | 0.686 | 620 2 | 0.7 | 541 | 100000 | 17432 | 30001 | 0.581 | 723 2 | 0.8 | 541 | 20001 | 12894 | 20001 | 0.645 | 778 2 | 0.9 | 541 | 7570 | 7570 | 10001 | 0.757 | 832 2 | 0.95 | 541 | 100000 | 6605 | 5001 | 1.321 | 885 2 | 0.99 | 541 | 100000 | 2598 | 1001 | 2.595 | 885 (44 rows)