[PERFORM] INSERT OR UPDATE WITHOUT SELECT

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

[PERFORM] Why the 8.1 plan is worst than 7.4?

Hi, I have 2 servers, one of them has a 7.4 postgres and the other has a 8.1 I have this query: select fagrempr,fagrdocr,fagrserr,fagrparr from arqcfat left join arqfagr on fagrorig = 'CFAT' and fagrdocu = cfatdocu and fagrempe = cfatempe and fagrseri = cfatseri where cfatdata between '20