============================ cat24 ============================ Record count and distribution as before. First vacuum analyze after patch: tablename | attname | n_distinct | most_common_vals ---------------------------+---------+------------+-------------------- cat24_ticket_doc_id | tdnr | -1 | Second vacuum analyze: cat24_ticket_doc_id | tdnr | -0.584636 | {0557163156676,0557171409232,0557783351224} Third: cat24_ticket_doc_id | tdnr | -0.678662 | {0557188523569,0557194868274} Fourth: cat24_ticket_doc_id | tdnr | -0.808627 | {0551010202799} Fifth: cat24_ticket_doc_id | tdnr | -1 | Several more yield '-1'... ============================ cat30 ============================ Number of records: 5488186 Distribution: tdnr_ct | ct ---------+-------- 2 | 178527 4 | 125079 6 | 139028 8 | 316861 10 | 77236 12 | 18087 14 | 14195 16 | 3022 18 | 1029 20 | 318 22 | 13 24 | 2 26 | 1 32 | 1 Before: cat30_fare_tax_amount | tdnr | 128089 | {0557007851240,0557126929304,0557185416107} After patch and vacuum analyze: cat30_fare_tax_amount | tdnr | -0.214451 | {0551010729897,0557023513126,0557194169234} Second vacuum analyze: cat30_fare_tax_amount | tdnr | 457122 | {0557010812306,0557030453091,0557108514272,0557130186286,0557146509902,0557164559734,0557715711564,0557750137265,0557788976042} Third vacuum analyze: cat30_fare_tax_amount | tdnr | 509120 | {0557102646528,0557109924905,0557119731818,0557133277708,0557168762802,0557186151285,0557723160441,0557727507345} Fourth: cat30_fare_tax_amount | tdnr | 509120 | {0557089865931,0557141022517,0557161226285,0557193916796,0557197124815,0557748120318,0557780558929,0557798676041} Fifth: cat30_fare_tax_amount | tdnr | -0.214451 | {0551533331462,0557050661925,0557781703471} Sixth: cat30_fare_tax_amount | tdnr | -0.169903 | {0557044794974,0557186887198,0557781470273,0557784817823} ============================ cat_conj ============================ Number of records: 1061795 Distribution: tdnr_ct | ct ---------+-------- 1 | 710328 2 | 161714 3 | 9088 4 | 138 5 | 13 6 | 12 7 | 10 16 | 1 Before: cat_conjunctive | tdnr | 56403 | {0557788105364} After patch and vacuum analyze: cat_conjunctive | tdnr | -0.679545 | {0551044984931,0557172444541} Again: cat_conjunctive | tdnr | -0.514463 | {0551028769304,0557158856476,0557182537023,0557192609769} Again: cat_conjunctive | tdnr | -0.809253 | {0557051616153} Again: cat_conjunctive | tdnr | -1 |