test where id = 50000;â Few times I added 100,000 records, applied

cast the 50000 to int8 and it will use the index

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to