Dear hackers, > Next we should add some test codes. I will continue considering but please > post > anything > If you have idea.
And I did, PSA the patch. This patch adds two parts in hash_index.sql. In the first part, the primary bucket page is filled by live tuples and some overflow pages are by dead ones. This leads removal of overflow pages without moving tuples. HEAD will crash if this were executed, which is already reported on hackers. The second one tests a case (ntups == 0 && is_prim_bucket_same_wrt == false && is_prev_bucket_same_wrt == true), which is never done before. Also, I measured the execution time of before/after patching. Below is a madian for 9 measurements. BEFORE -> AFTER 647 ms -> 710 ms This means that the execution time increased -10%, it will not affect so much. How do you think? Best Regards, Hayato Kuroda FUJITSU LIMITED
fix_hash_squeeze_wal_4.patch
Description: fix_hash_squeeze_wal_4.patch