create table t1 (a int primary key, b int) partition by hash (a); create table t1_00 partition of t1 for values with (modulus 64, remainder 0); create table t1_01 partition of t1 for values with (modulus 64, remainder 1); create table t1_02 partition of t1 for values with (modulus 64, remainder 2); create table t1_03 partition of t1 for values with (modulus 64, remainder 3); create table t1_04 partition of t1 for values with (modulus 64, remainder 4); create table t1_05 partition of t1 for values with (modulus 64, remainder 5); create table t1_06 partition of t1 for values with (modulus 64, remainder 6); create table t1_07 partition of t1 for values with (modulus 64, remainder 7); create table t1_08 partition of t1 for values with (modulus 64, remainder 8); create table t1_09 partition of t1 for values with (modulus 64, remainder 9); create table t1_10 partition of t1 for values with (modulus 64, remainder 10); create table t1_11 partition of t1 for values with (modulus 64, remainder 11); create table t1_12 partition of t1 for values with (modulus 64, remainder 12); create table t1_13 partition of t1 for values with (modulus 64, remainder 13); create table t1_14 partition of t1 for values with (modulus 64, remainder 14); create table t1_15 partition of t1 for values with (modulus 64, remainder 15); create table t1_16 partition of t1 for values with (modulus 64, remainder 16); create table t1_17 partition of t1 for values with (modulus 64, remainder 17); create table t1_18 partition of t1 for values with (modulus 64, remainder 18); create table t1_19 partition of t1 for values with (modulus 64, remainder 19); create table t1_20 partition of t1 for values with (modulus 64, remainder 20); create table t1_21 partition of t1 for values with (modulus 64, remainder 21); create table t1_22 partition of t1 for values with (modulus 64, remainder 22); create table t1_23 partition of t1 for values with (modulus 64, remainder 23); create table t1_24 partition of t1 for values with (modulus 64, remainder 24); create table t1_25 partition of t1 for values with (modulus 64, remainder 25); create table t1_26 partition of t1 for values with (modulus 64, remainder 26); create table t1_27 partition of t1 for values with (modulus 64, remainder 27); create table t1_28 partition of t1 for values with (modulus 64, remainder 28); create table t1_29 partition of t1 for values with (modulus 64, remainder 29); create table t1_30 partition of t1 for values with (modulus 64, remainder 30); create table t1_31 partition of t1 for values with (modulus 64, remainder 31); create table t1_32 partition of t1 for values with (modulus 64, remainder 32); create table t1_33 partition of t1 for values with (modulus 64, remainder 33); create table t1_34 partition of t1 for values with (modulus 64, remainder 34); create table t1_35 partition of t1 for values with (modulus 64, remainder 35); create table t1_36 partition of t1 for values with (modulus 64, remainder 36); create table t1_37 partition of t1 for values with (modulus 64, remainder 37); create table t1_38 partition of t1 for values with (modulus 64, remainder 38); create table t1_39 partition of t1 for values with (modulus 64, remainder 39); create table t1_40 partition of t1 for values with (modulus 64, remainder 40); create table t1_41 partition of t1 for values with (modulus 64, remainder 41); create table t1_42 partition of t1 for values with (modulus 64, remainder 42); create table t1_43 partition of t1 for values with (modulus 64, remainder 43); create table t1_44 partition of t1 for values with (modulus 64, remainder 44); create table t1_45 partition of t1 for values with (modulus 64, remainder 45); create table t1_46 partition of t1 for values with (modulus 64, remainder 46); create table t1_47 partition of t1 for values with (modulus 64, remainder 47); create table t1_48 partition of t1 for values with (modulus 64, remainder 48); create table t1_49 partition of t1 for values with (modulus 64, remainder 49); create table t1_50 partition of t1 for values with (modulus 64, remainder 50); create table t1_51 partition of t1 for values with (modulus 64, remainder 51); create table t1_52 partition of t1 for values with (modulus 64, remainder 52); create table t1_53 partition of t1 for values with (modulus 64, remainder 53); create table t1_54 partition of t1 for values with (modulus 64, remainder 54); create table t1_55 partition of t1 for values with (modulus 64, remainder 55); create table t1_56 partition of t1 for values with (modulus 64, remainder 56); create table t1_57 partition of t1 for values with (modulus 64, remainder 57); create table t1_58 partition of t1 for values with (modulus 64, remainder 58); create table t1_59 partition of t1 for values with (modulus 64, remainder 59); create table t1_60 partition of t1 for values with (modulus 64, remainder 60); create table t1_61 partition of t1 for values with (modulus 64, remainder 61); create table t1_62 partition of t1 for values with (modulus 64, remainder 62); create table t1_63 partition of t1 for values with (modulus 64, remainder 63); insert into t1 (select i, i from generate_series(1, 10000000) as i); analyze;