Emi Lu <emilu@xxxxxxxxxxxxxxx> writes: > But I got a warning msg from postgresql as: > foreign key constraint "Aclo3_fk" will require costly sequential scans Try to make the referencing and referenced columns the same datatype. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend