2023-06-07 23:46:15.130 PDT [260646][client backend] [pg_regress/insert][6/681:2269] LOG: simple deletion of index "pg_type_typname_nsp_index", block 6: n_tup: 251, including high key first: (typname, typnamespace)=(column_column_usage, 13858) h_key: (typname, typnamespace)=(pg_largeobject) finished up on heap block 28 (having accessed 4 blocks in total) 10. (typname, typnamespace)=(copydml_test, 2200) w TID (25,3) will be deleted freeing 36 28. (typname, typnamespace)=(enumtest, 2200) w TID (18,7) will be deleted freeing 28 29. (typname, typnamespace)=(enumtest_bogus_child, 2200) w TID (18,21) will be deleted freeing 44 30. (typname, typnamespace)=(enumtest_child, 2200) w TID (18,17) will be deleted freeing 36 31. (typname, typnamespace)=(enumtest_parent, 2200) w TID (18,13) will be deleted freeing 36 43. (typname, typnamespace)=(float8range_test, 2200) w TID (18,43) will be deleted freeing 36 54. (typname, typnamespace)=(hash_parted, 2200) w TID (27,34) will be deleted freeing 28 56. (typname, typnamespace)=(hpart0, 2200) w TID (27,36) will be deleted freeing 28 57. (typname, typnamespace)=(hpart1, 2200) w TID (27,38) will be deleted freeing 28 58. (typname, typnamespace)=(hpart2, 2200) w TID (27,40) will be deleted freeing 28 59. (typname, typnamespace)=(hpart3, 2200) w TID (27,42) will be deleted freeing 28 61. (typname, typnamespace)=(i8r_array, 2200) w TID (18,61) will be deleted freeing 28 68. (typname, typnamespace)=(insert_test_type, 2200) w TID (25,15) will be deleted freeing 36 73. (typname, typnamespace)=(inserttest, 2200) w TID (25,1) will be deleted freeing 28 (LP_DEAD bit set) 74. (typname, typnamespace)=(inserttest, 2200) w TID (25,17) will be deleted freeing 28 75. (typname, typnamespace)=(inserttest2, 2200) w TID (25,19) will be deleted freeing 28 104. (typname, typnamespace)=(large_tuple_test, 2200) w TID (25,9) will be deleted freeing 36 107. (typname, typnamespace)=(list_parted, 2200) w TID (25,31) will be deleted freeing 28 (LP_DEAD bit set) 108. (typname, typnamespace)=(list_parted, 2200) w TID (27,44) will be deleted freeing 28 109. (typname, typnamespace)=(lparted_nonullpart, 2200) w TID (27,54) will be deleted freeing 36 110. (typname, typnamespace)=(lparted_nonullpart_a, 2200) w TID (27,56) will be deleted freeing 44 124. (typname, typnamespace)=(mlparted5, 2200) w TID (27,66) will be deleted freeing 28 (LP_DEAD bit set) 128. (typname, typnamespace)=(mlparted5a, 2200) w TID (27,68) will be deleted freeing 28 136. (typname, typnamespace)=(mydomain, 2200) w TID (18,45) will be deleted freeing 28 (LP_DEAD bit set) 138. (typname, typnamespace)=(mydomainmultirange, 2200) w TID (18,48) will be deleted freeing 36 (LP_DEAD bit set) 140. (typname, typnamespace)=(mydomainrange, 2200) w TID (18,47) will be deleted freeing 36 (LP_DEAD bit set) 166. (typname, typnamespace)=(numrange_test2, 2200) w TID (18,9) will be deleted freeing 36 173. (typname, typnamespace)=(part1, 2200) w TID (25,23) will be deleted freeing 28 174. (typname, typnamespace)=(part2, 2200) w TID (25,25) will be deleted freeing 28 175. (typname, typnamespace)=(part3, 2200) w TID (25,27) will be deleted freeing 28 176. (typname, typnamespace)=(part4, 2200) w TID (25,29) will be deleted freeing 28 177. (typname, typnamespace)=(part_aa_bb, 2200) w TID (25,33) will be deleted freeing 28 178. (typname, typnamespace)=(part_cc_dd, 2200) w TID (25,35) will be deleted freeing 28 179. (typname, typnamespace)=(part_def, 2200) w TID (27,16) will be deleted freeing 28 180. (typname, typnamespace)=(part_default, 2200) w TID (27,2) will be deleted freeing 36 (LP_DEAD bit set) 181. (typname, typnamespace)=(part_default, 2200) w TID (27,10) will be deleted freeing 36 (LP_DEAD bit set) 182. (typname, typnamespace)=(part_default, 2200) w TID (27,46) will be deleted freeing 36 183. (typname, typnamespace)=(part_default_p1, 2200) w TID (27,12) will be deleted freeing 36 184. (typname, typnamespace)=(part_default_p2, 2200) w TID (27,14) will be deleted freeing 36 185. (typname, typnamespace)=(part_ee_ff, 2200) w TID (25,39) will be deleted freeing 28 186. (typname, typnamespace)=(part_ee_ff1, 2200) w TID (25,41) will be deleted freeing 28 187. (typname, typnamespace)=(part_ee_ff2, 2200) w TID (25,43) will be deleted freeing 28 188. (typname, typnamespace)=(part_ee_ff3, 2200) w TID (27,28) will be deleted freeing 28 189. (typname, typnamespace)=(part_ee_ff3_1, 2200) w TID (27,30) will be deleted freeing 36 190. (typname, typnamespace)=(part_ee_ff3_2, 2200) w TID (27,32) will be deleted freeing 36 191. (typname, typnamespace)=(part_gg, 2200) w TID (27,18) will be deleted freeing 28 192. (typname, typnamespace)=(part_gg1, 2200) w TID (27,20) will be deleted freeing 28 193. (typname, typnamespace)=(part_gg2, 2200) w TID (27,22) will be deleted freeing 28 194. (typname, typnamespace)=(part_gg2_1, 2200) w TID (27,24) will be deleted freeing 28 195. (typname, typnamespace)=(part_gg2_2, 2200) w TID (27,26) will be deleted freeing 28 196. (typname, typnamespace)=(part_null, 2200) w TID (25,37) will be deleted freeing 28 197. (typname, typnamespace)=(part_xx_yy, 2200) w TID (27,4) will be deleted freeing 28 198. (typname, typnamespace)=(part_xx_yy_defpart, 2200) w TID (27,8) will be deleted freeing 36 199. (typname, typnamespace)=(part_xx_yy_p1, 2200) w TID (27,6) will be deleted freeing 36 results: checked 70 tids out of 250 on page (28.00% of total on page), of which 54 (21.60% of total on page) deleted results: deleted tids plain 54, deleted tids posting 0, pagelsn: 0/3303FD8 results: exact free space 1716, exact TIDs deleted 54/LP_DEAD tuples 8 (RR 6.75), LP_DEAD-related table blocks 4 2023-06-07 23:46:15.130 PDT [260646][client backend] [pg_regress/insert][6/681:2269] STATEMENT: create table mlparted5_a partition of mlparted5_ab for values in ('a');